21 10038 150 Street, Surrey Listing #: R3040427
$748,800
2 Beds
2 Baths
1,306 Sqft
1991 Built
$389.35 mnt. fees
LOCATION! LOCATION! LOCATION! WELCOME TO MAYFIELD GREEN!!! RARELY available, quiet, peaceful and captivating place to live and enjoy life. A VERY high demand, well maintained complex. Some recent upgrades including a new dishwasher. Walking distance to Guildford Mall, library, rec centre, theatres, doctors clinics, banks & TNT. Bus stop across the street. Easy access to Hwy #1. OPEN HOUSE Sept 5th Fri 5-7PM /Sat & Sun Sept 6th & 7th 2-4PM
Taxes (2024): $2,591.60
Amenities
- Clubhouse
- Exercise Centre
- Caretaker
- Maintenance Grounds
- Management
- Recreation Facilities
- Snow Removal
- Gated
- Shopping Nearby
- In Unit
Features
- Washer
- Dryer
- Dishwasher
- Refrigerator
- Stove
- Window Coverings
Site Influences
- Gated
- Shopping Nearby
- Recreation Nearby
- Paved
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /usr/lib/php/pixilink/classes/Functions.php on line 285
Sort aborted: Server shutdown in progressSELECT listingid, inserted, listprice_2, bedrooms, IF (inserted between '2025-09-16 19:54:28' and '2025-09-18 07:54:28', 1, 0) as datematch, IF (inserted between '2025-09-15 07:54:28' and '2025-09-16 19:54:28', 1, 0) as datematch2, IF (inserted < '2025-09-15 07:54:28', DATEDIFF(inserted, '2025-09-18 07:54:28'), 0) as datematch3, IF (listprice_2 between 648800 and 798800, 1, 0) as pricematch, IF (bedrooms >= 2, 1, 0) as bedsmatch FROM boards.listings WHERE `table` = 'mlsr_listings' AND city = 'Surrey' AND class = '0' AND `status` = 'Active' AND reciprocity = 'Yes' AND listingid not in ('R3047932','R3047625','R3043881','R3045681','R3041489','R3040401','R3039825','R3039932','R3040291','R3039231','R3040427') order by datematch desc, datematch2 desc, datematch3 desc, pricematch desc, bedsmatch desc limit 3