SELECT DISTINCT(a.crea_id), a.office_name, a.office_id, b.crea_id, b.mls_id, STR_TO_DATE(b.last_updated,'%a, %d %b %Y') AS LASTUPDATED, b.street_address, b.city, b.province, b.postal, b.price, b.bedroom_total, b.bathroom_total, b.half_bath_total, b.size_interior, c.sequence_id, c.thumbURL, c.medURL, c.largeURL, d.thumbURL AS THUMBB, d.medURL AS MEDB, d.largeURL AS LARGEB FROM tbl_CREA_0_agents a INNER JOIN tbl_CREA_0 b ON (a.crea_id = b.crea_id AND a.office_id IN (291450)) LEFT JOIN tbl_CREA_0_photos c ON (a.crea_id = c.crea_id AND c.sequence_id = 1) LEFT JOIN tbl_CREA_0_photos d ON (a.crea_id = d.crea_id AND d.sequence_id = 0)ORDER BY b.price DESC, b.mls_id ASC
Agents of Change
100% Real Estate Agent Services | 100% REALTOR.CA Exposure | 3% Commission
506.386.5568
atlantic@3percentrealty.ca
Agents of Change
100% Real Estate Agent Services | 100% MLS System Exposure | 3% Commission
506.386.5568
atlantic@3percentrealty.ca
X

Search Our Listings

Search
X
Price Range
to
Beds:
Baths:
Property Type:
Building Type:
Size:
Reset Search
Sort By 
Array
(
    [crea_id] => 25133271
    [office_name] => 3 Percent Realty Atlantic Inc.
    [office_id] => 291450
    [mls_id] => M149440
    [LASTUPDATED] => 2023-01-26
    [street_address] => 121 Salengro CRES
    [city] => Moncton
    [province] => New Brunswick
    [postal] => E1G6B3
    [price] => 599900.00
    [bedroom_total] => 4
    [bathroom_total] => 4
    [half_bath_total] => 1
    [size_interior] => 1540 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638065427001600000/reb45/lowres/0/m149440_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638065427001600000/reb45/medres/0/m149440_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638065427001600000/reb45/highres/0/m149440_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$599,900
1540 sqft | 4 | 3.5
121 Salengro CRES
Moncton, New Brunswick
E1G6B3
MLS#M149440
Tracey Mullin: 506.866.6954 / Email 
Array
(
    [crea_id] => 25178136
    [office_name] => 3 Percent Realty Atlantic Inc.
    [office_id] => 291450
    [mls_id] => M149645
    [LASTUPDATED] => 2023-02-02
    [street_address] => 15 Rosebank
    [city] => Riverview
    [province] => New Brunswick
    [postal] => E1B0R5
    [price] => 547800.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1575 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638101094204370000/reb45/lowres/5/m149645_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638101094204370000/reb45/medres/5/m149645_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638101094204370000/reb45/highres/5/m149645_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$547,800
1575 sqft | 3 | 3
15 Rosebank
Riverview, New Brunswick
E1B0R5
MLS#M149645
Tracey Mullin: 506.866.6954 / Email 
Array
(
    [crea_id] => 25236759
    [office_name] => 3 Percent Realty Atlantic Inc.
    [office_id] => 291450
    [mls_id] => M149871
    [LASTUPDATED] => 2023-02-01
    [street_address] => 162 Oak Ridge DR
    [city] => Moncton
    [province] => New Brunswick
    [postal] => E1G0M2
    [price] => 499900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1240 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638108531259230000/reb45/lowres/1/m149871_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638108531259230000/reb45/medres/1/m149871_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638108531259230000/reb45/highres/1/m149871_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$499,900
1240 sqft | 3 | 2
162 Oak Ridge DR
Moncton, New Brunswick
E1G0M2
MLS#M149871
Tracey Mullin: 506.866.6954 / Email 
Array
(
    [crea_id] => 25071155
    [office_name] => 3 Percent Realty Atlantic Inc.
    [office_id] => 291450
    [mls_id] => M149153
    [LASTUPDATED] => 2023-01-20
    [street_address] => 203 Rennick RD
    [city] => Moncton
    [province] => New Brunswick
    [postal] => E1G4X9
    [price] => 369900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 1372 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638065426999470000/reb45/lowres/3/m149153_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638065426999470000/reb45/medres/3/m149153_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638065426999470000/reb45/highres/3/m149153_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$369,900
1372 sqft | 3 | 2.5
203 Rennick RD
Moncton, New Brunswick
E1G4X9
MLS#M149153
Tracey Mullin: 506.866.6954 / Email 
Array
(
    [crea_id] => 25038730
    [office_name] => 3 Percent Realty Atlantic Inc.
    [office_id] => 291450
    [mls_id] => M149006
    [LASTUPDATED] => 2023-02-03
    [street_address] => 9 Jayden LANE
    [city] => Moncton
    [province] => New Brunswick
    [postal] => E1G0S1
    [price] => 249900.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 950 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638110180997000000/reb45/lowres/6/m149006_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638110180997000000/reb45/medres/6/m149006_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638110180997000000/reb45/highres/6/m149006_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$249,900
950 sqft | 2 | 1
9 Jayden LANE
Moncton, New Brunswick
E1G0S1
MLS#M149006
Tracey Mullin: 506.866.6954 / Email 
Array
(
    [crea_id] => 25201188
    [office_name] => 3 Percent Realty Atlantic Inc.
    [office_id] => 291450
    [mls_id] => M149736
    [LASTUPDATED] => 2023-01-30
    [street_address] => 34 Simpson CRT
    [city] => Riverview
    [province] => New Brunswick
    [postal] => E1B4P2
    [price] => 249900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 1
    [size_interior] => 975 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638106269619000000/reb45/lowres/6/m149736_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638106269619000000/reb45/medres/6/m149736_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638106269619000000/reb45/highres/6/m149736_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$249,900
975 sqft | 3 | 1.5
34 Simpson CRT
Riverview, New Brunswick
E1B4P2
MLS#M149736
Tracey Mullin: 506.866.6954 / Email 
Array
(
    [crea_id] => 25218265
    [office_name] => 3 Percent Realty Atlantic Inc.
    [office_id] => 291450
    [mls_id] => M149805
    [LASTUPDATED] => 2023-01-27
    [street_address] => 143 North ST
    [city] => Moncton
    [province] => New Brunswick
    [postal] => E1C5X9
    [price] => 195000.00
    [bedroom_total] => 4
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1425 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638102591066030000/reb45/lowres/5/m149805_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638102591066030000/reb45/medres/5/m149805_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638102591066030000/reb45/highres/5/m149805_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$195,000
1425 sqft | 4 | 1
143 North ST
Moncton, New Brunswick
E1C5X9
MLS#M149805
Tracey Mullin: 506.866.6954 / Email 
Array
(
    [crea_id] => 25218266
    [office_name] => 3 Percent Realty Atlantic Inc.
    [office_id] => 291450
    [mls_id] => M149804
    [LASTUPDATED] => 2023-01-27
    [street_address] => 85 Hayward LANE
    [city] => Riverview
    [province] => New Brunswick
    [postal] => E1B0G3
    [price] => 162500.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1120 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638102603141330000/reb45/lowres/4/m149804_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638102603141330000/reb45/medres/4/m149804_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638102603141330000/reb45/highres/4/m149804_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$162,500
1120 sqft | 3 | 2
85 Hayward LANE
Riverview, New Brunswick
E1B0G3
MLS#M149804
Tracey Mullin: 506.866.6954 / Email 
Array
(
    [crea_id] => 24904265
    [office_name] => 3 Percent Realty Atlantic Inc.
    [office_id] => 291450
    [mls_id] => M147345
    [LASTUPDATED] => 2022-09-27
    [street_address] => Lot 21-10 Balfour CRT
    [city] => Moncton
    [province] => New Brunswick
    [postal] => E1G4W4
    [price] => 82900.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637998724147770000/reb45/lowres/5/m147345_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637998724147770000/reb45/medres/5/m147345_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637998724147770000/reb45/highres/5/m147345_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$82,900
| 0 | 0
Lot 21-10 Balfour CRT
Moncton, New Brunswick
E1G4W4
MLS#M147345
Tracey Mullin: 506.866.6954 / Email 
Array
(
    [crea_id] => 25236841
    [office_name] => 3 Percent Realty Atlantic Inc.
    [office_id] => 291450
    [mls_id] => M149890
    [LASTUPDATED] => 2023-02-01
    [street_address] => Lot Octave ST
    [city] => Shediac Bridge
    [province] => New Brunswick
    [postal] => E4R1A6
    [price] => 54900.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638108542978330000/reb45/lowres/0/m149890_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638108542978330000/reb45/medres/0/m149890_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638108542978330000/reb45/highres/0/m149890_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$54,900
| 0 | 0
Lot Octave ST
Shediac Bridge, New Brunswick
E4R1A6
MLS#M149890
Tracey Mullin: 506.866.6954 / Email 
Array
(
    [crea_id] => 25172337
    [office_name] => 3 Percent Realty Atlantic Inc.
    [office_id] => 291450
    [mls_id] => M149627
    [LASTUPDATED] => 2023-01-18
    [street_address] => 9 Stonington RD
    [city] => Stilesville
    [province] => New Brunswick
    [postal] => E1G5X9
    [price] => 44900.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638088731213970000/reb45/lowres/7/m149627_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638088731213970000/reb45/medres/7/m149627_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638088731213970000/reb45/highres/7/m149627_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$44,900
| 0 | 0
9 Stonington RD
Stilesville, New Brunswick
E1G5X9
MLS#M149627
Tracey Mullin: 506.866.6954 / Email
Sort By
Agents of Change
3% Realty Atlantic
506.386.5568 | atlantic@3percentrealty.ca
1830 Mountain Road, Suite B
Moncton,
E1G 1A9
This site's content is the responsibility of ,
The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. The trademarks REALTOR®, REALTORS® and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA.

Copyright © 2023 3% Realty Inc. All Rights Reserved
Site Designed and Built in 2018 by Tobias Crichton Studios.