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 FROM tbl_CREA_0_agents a INNER JOIN tbl_CREA_0 b ON (a.crea_id = b.crea_id) LEFT JOIN tbl_CREA_0_photos c ON (a.crea_id = c.crea_id AND c.sequence_id = 1) WHERE a.crea_id IN (25299256,25229766,25328123,25232917,25329235,25294323,25329341,25195278,25321010,25194832,25195279,25200108,25103733) ORDER BY b.price DESC, b.mls_id ASC
X
Search
X
Price Range
to
Beds:
Baths:
Property Type:
Building Type:
Size:
Reset Search
Sort By 
Array
(
    [crea_id] => 25299256
    [office_name] => 2 Percent Realty Experts
    [office_id] => 279547
    [mls_id] => R2754711
    [LASTUPDATED] => 2023-02-24
    [street_address] => 3707 MUNRO WAY
    [city] => Prince George
    [province] => British Columbia
    [postal] => V2N0C8
    [price] => 999900.00
    [bedroom_total] => 5
    [bathroom_total] => 5
    [half_bath_total] => 0
    [size_interior] => 3527 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638128471078930000/reb2/lowres/1/r2754711_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638128471078930000/reb2/medres/1/r2754711_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638128471078930000/reb2/highres/1/r2754711_1.jpg
)
View
$999,900
3527 sqft | 5 | 5
3707 MUNRO WAY
Prince George, British Columbia
V2N0C8
MLS#R2754711
Jesse Suran : 250.649.8147 / Email 
Array
(
    [crea_id] => 25229766
    [office_name] => 2 Percent Realty Experts
    [office_id] => 279547
    [mls_id] => R2749148
    [LASTUPDATED] => 2023-03-04
    [street_address] => 1225 ORIZABA COURT
    [city] => Prince George
    [province] => British Columbia
    [postal] => V2N0B7
    [price] => 799900.00
    [bedroom_total] => 6
    [bathroom_total] => 4
    [half_bath_total] => 0
    [size_interior] => 3720 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638134801706200000/reb2/lowres/8/r2749148_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638134801706200000/reb2/medres/8/r2749148_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638134801706200000/reb2/highres/8/r2749148_1.jpg
)
View
$799,900
3720 sqft | 6 | 4
1225 ORIZABA COURT
Prince George, British Columbia
V2N0B7
MLS#R2749148
Kevin Anderson: 250.981.8182 / Email 
Array
(
    [crea_id] => 25328123
    [office_name] => 2 Percent Realty Experts
    [office_id] => 279547
    [mls_id] => R2756957
    [LASTUPDATED] => 2023-03-09
    [street_address] => 4312 FLYNN AVENUE
    [city] => Prince George
    [province] => British Columbia
    [postal] => V2M5Y9
    [price] => 524900.00
    [bedroom_total] => 7
    [bathroom_total] => 4
    [half_bath_total] => 0
    [size_interior] => 3000 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638134539973270000/reb2/lowres/7/r2756957_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638134539973270000/reb2/medres/7/r2756957_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638134539973270000/reb2/highres/7/r2756957_1.jpg
)
View
$524,900
3000 sqft | 7 | 4
4312 FLYNN AVENUE
Prince George, British Columbia
V2M5Y9
MLS#R2756957
Kevin Anderson: 250.981.8182 / Email 
Array
(
    [crea_id] => 25232917
    [office_name] => 2 Percent Realty Experts
    [office_id] => 279547
    [mls_id] => R2749503
    [LASTUPDATED] => 2023-02-01
    [street_address] => 2546 LORNE CRESCENT
    [city] => Prince George
    [province] => British Columbia
    [postal] => V2N1E4
    [price] => 489900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1800 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638107981655730000/reb2/lowres/3/r2749503_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638107981655730000/reb2/medres/3/r2749503_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638107981655730000/reb2/highres/3/r2749503_1.jpg
)
View
$489,900
1800 sqft | 3 | 2
2546 LORNE CRESCENT
Prince George, British Columbia
V2N1E4
MLS#R2749503
Kevin Anderson: 250.981.8182 / Email 
Array
(
    [crea_id] => 25329235
    [office_name] => 2 Percent Realty Experts
    [office_id] => 279547
    [mls_id] => R2757044
    [LASTUPDATED] => 2023-03-08
    [street_address] => 2401 13688 100 AVENUE
    [city] => Surrey
    [province] => British Columbia
    [postal] => V3T0G5
    [price] => 489000.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 529.0000
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638135718724130000/reb6/lowres/4/R2757044_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638135718724130000/reb6/medres/4/R2757044_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638135718724130000/reb6/highres/4/R2757044_1.jpg
)
View
$489,000
529.0000 | 1 | 1
2401 13688 100 AVENUE
Surrey, British Columbia
V3T0G5
MLS#R2757044
Manraj Randhawa: 604.652.1394 / Email 
Array
(
    [crea_id] => 25294323
    [office_name] => 2 Percent Realty Experts
    [office_id] => 279547
    [mls_id] => R2754103
    [LASTUPDATED] => 2023-03-03
    [street_address] => 2396 JASPER STREET
    [city] => Prince George
    [province] => British Columbia
    [postal] => V2L1P1
    [price] => 439900.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 2722 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638128471000000000/reb2/lowres/3/r2754103_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638128471000000000/reb2/medres/3/r2754103_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638128471000000000/reb2/highres/3/r2754103_1.jpg
)
View
$439,900
2722 sqft | 4 | 2
2396 JASPER STREET
Prince George, British Columbia
V2L1P1
MLS#R2754103
Kevin Anderson: 250.981.8182 / Email 
Array
(
    [crea_id] => 25329341
    [office_name] => 2 Percent Realty Experts
    [office_id] => 279547
    [mls_id] => R2757043
    [LASTUPDATED] => 2023-03-17
    [street_address] => 10288 JENSEN ROAD
    [city] => Prince George
    [province] => British Columbia
    [postal] => V2N4Y7
    [price] => 439900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1980 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638146660731770000/reb2/lowres/3/r2757043_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638146660731770000/reb2/medres/3/r2757043_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638146660731770000/reb2/highres/3/r2757043_1.jpg
)
View
$439,900
1980 sqft | 3 | 2
10288 JENSEN ROAD
Prince George, British Columbia
V2N4Y7
MLS#R2757043
Jesse Suran : 250.649.8147 / Email 
Array
(
    [crea_id] => 25195278
    [office_name] => 2 Percent Realty Experts
    [office_id] => 279547
    [mls_id] => R2746563
    [LASTUPDATED] => 2023-01-21
    [street_address] => 1737 REDWOOD STREET
    [city] => Prince George
    [province] => British Columbia
    [postal] => V2L2N3
    [price] => 429000.00
    [bedroom_total] => 6
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 2360 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638095771890470000/reb2/lowres/3/r2746563_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638095771890470000/reb2/medres/3/r2746563_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638095771890470000/reb2/highres/3/r2746563_1.jpg
)
View
$429,000
2360 sqft | 6 | 3
1737 REDWOOD STREET
Prince George, British Columbia
V2L2N3
MLS#R2746563
Kevin Anderson: 250.981.8182 / Email 
Array
(
    [crea_id] => 25321010
    [office_name] => 2 Percent Realty Experts
    [office_id] => 279547
    [mls_id] => R2756507
    [LASTUPDATED] => 2023-03-06
    [street_address] => 6219 BERGER CRESCENT
    [city] => Prince George
    [province] => British Columbia
    [postal] => V2K4S9
    [price] => 419000.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 2180 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638132990983900000/reb2/lowres/7/r2756507_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638132990983900000/reb2/medres/7/r2756507_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638132990983900000/reb2/highres/7/r2756507_1.jpg
)
View
$419,000
2180 sqft | 4 | 3
6219 BERGER CRESCENT
Prince George, British Columbia
V2K4S9
MLS#R2756507
Graham Smith: 250.613.2860 / Email 
Array
(
    [crea_id] => 25194832
    [office_name] => 2 Percent Realty Experts
    [office_id] => 279547
    [mls_id] => R2746515
    [LASTUPDATED] => 2023-02-11
    [street_address] => 1950 VINE STREET
    [city] => Prince George
    [province] => British Columbia
    [postal] => V2L2W8
    [price] => 399000.00
    [bedroom_total] => 5
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1826 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638095771890300000/reb2/lowres/5/r2746515_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638095771890300000/reb2/medres/5/r2746515_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638095771890300000/reb2/highres/5/r2746515_1.jpg
)
View
$399,000
1826 sqft | 5 | 2
1950 VINE STREET
Prince George, British Columbia
V2L2W8
MLS#R2746515
Kevin Anderson: 250.981.8182 / Email 
Array
(
    [crea_id] => 25195279
    [office_name] => 2 Percent Realty Experts
    [office_id] => 279547
    [mls_id] => R2746544
    [LASTUPDATED] => 2023-01-19
    [street_address] => 1885-1887 VINE STREET
    [city] => Prince George
    [province] => British Columbia
    [postal] => V2L2W7
    [price] => 399000.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1260 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638095789576000000/reb2/lowres/4/r2746544_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638095789576000000/reb2/medres/4/r2746544_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638095789576000000/reb2/highres/4/r2746544_1.jpg
)
View
$399,000
1260 sqft | 4 | 2
1885-1887 VINE STREET
Prince George, British Columbia
V2L2W7
MLS#R2746544
Kevin Anderson: 250.981.8182 / Email 
Array
(
    [crea_id] => 25200108
    [office_name] => 2 Percent Realty Experts
    [office_id] => 279547
    [mls_id] => R2746971
    [LASTUPDATED] => 2023-02-27
    [street_address] => 3562 HILBORN ROAD
    [city] => Quesnel
    [province] => British Columbia
    [postal] => V2J3P6
    [price] => 254900.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1077 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638098251114700000/reb2/lowres/1/r2746971_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638098251114700000/reb2/medres/1/r2746971_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638098251114700000/reb2/highres/1/r2746971_1.jpg
)
View
$254,900
1077 sqft | 3 | 1
3562 HILBORN ROAD
Quesnel, British Columbia
V2J3P6
MLS#R2746971
Jesse Suran : 250.649.8147 / Email 
Array
(
    [crea_id] => 25103733
    [office_name] => 2 Percent Realty Experts
    [office_id] => 279547
    [mls_id] => R2740704
    [LASTUPDATED] => 2023-03-08
    [street_address] => 1754 UPLAND STREET
    [city] => Prince George
    [province] => British Columbia
    [postal] => V2L2V6
    [price] => 229900.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 640 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638053346106300000/reb2/lowres/4/r2740704_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638053346106300000/reb2/medres/4/r2740704_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638053346106300000/reb2/highres/4/r2740704_1.jpg
)
View
$229,900
640 sqft | 2 | 1
1754 UPLAND STREET
Prince George, British Columbia
V2L2V6
MLS#R2740704
Kevin Anderson: 250.981.8182 / Email
Sort By
Amolak Johal
This site's content is the responsibility of Amolak Johal | 2018 Privacy Policy
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 2% Realty Inc. All Rights Reserved
Site Designed and Built by Tobias Crichton Studios.