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
Agents of Change
100% Real Estate Agent Services | 100% MLS System Exposure | 3% Commission
506.386.5568

Search Our Listings

Search
X
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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$44,900
| 0 | 0
9 Stonington RD
Stilesville, New Brunswick
E1G5X9
MLS#M149627
Tracey Mullin: 506.866.6954 / Email
Sort By