meta_query='key:subdist__c;value:Glen Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='336318' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15605
[post_author] => 4
[post_date] => 2018-11-02 02:30:48
[post_date_gmt] => 2018-11-02 02:30:48
[post_content] => Once dismissed as 'south of Noe Valley,' Glen Park is now embraced and adored for an I-280 on-ramp to Silicon Valley and a BART station to everywhere else. Start your day with coffee at a not-a-corporate-copycat coffeehouse in the heart of the village, stroll on to the neighborhood public library branch and then off for a hike/jog/bike/climb through Glen Canyon Park? Yes you can in Glen Park.
[post_title] => Glen Park
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => glen-park-2
[to_ping] =>
[pinged] =>
[post_modified] => 2023-06-23 08:31:35
[post_modified_gmt] => 2023-06-23 15:31:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15605
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 3 Mercato Court, San Francisco, CA, 94131
ffd_mls_id, 423761112
ffd_salesforce_id, a0E8W00000coglmUAA
num_of_fireplaces__c, 3
num_of_rooms__c, 10
of_units__c, 0
address2__c, 3 Mercato Court, San Francisco, CA, 94131
pba__address_pb__c, 3 Mercato Court, San Francisco, CA, 94131
agent_only_remarks__c, Disclosure package including super clean pest report and home inspections are now available - please email request to [email protected]. Roof and rear gutters have just been replaced on August 18, 2023. Agents - amazing views are best shown in the afternoon and also are breathtaking at night. Note - Realist shows 2 bathrooms but home is legally 2.5 (email confirmation from city is included in disclosure package).
appliances__c, Disposal;Hood Over Range;Free Standing Gas Range
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1977
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2023-08-04T20:47:57.000+0000
days_on_market__c, 24
dom__c, 8
ffd_description_pb, Extraordinary fully detached home in private cul-de-sac with jaw-dropping views! Gorgeously remodeled, this 4 bedroom, 2.5 bath home is spread over 3,625 sq ft and has been thoughtfully designed for today's modern lifestyle. The main level offers an open living floor plan with soaring ceilings that leads to your balcony with jaw-dropping views. Perfect for entertaining, this home offers a modern chef's kitchen that features an island with double waterfall edges encased in stunning quartz, custom cabinets, and luxury SS appliances. Head upstairs to an expansive room featuring a large wet bar that can be used as a family room or game room. The primary on-suite features a walk-in closet, sitting room (perfect for a home office or baby's room), and a spa-inspired bathroom with a luxurious soaking tub and extra-large shower. Oversized garage easily fits 2 cars side by side plus extra storage and washer/dryer/sink. Just steps to Glen Park Village, shops, restaurants, and Canyon Market. Quick access to Glen Park BART and freeways makes for care-free urban living!
district__c, SF District 5
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Electric;Family Room
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 450
pba__hoafrequency_pb__c, Annually
hoa_name__c, Mira Glen
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Cathedral Ceiling;Wet Bar
ffd_lastmodifieddate, 2023-08-28T20:05:37.000+0000
pba__latitude_pb__c, 37.735063
pba__latitude_property__c, 37.735063
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2023-08-04
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Morgan
pba__listing_agent_lastname__c, Cook
listing_agent_mls_id__c, 808184
ffd_listingagentname, Morgan R Cook
listing_agent_number__c, 1039152
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP31
listing_office_name__c, Compass
listing_office_number__c, 27894
pba__listingprice_pb__c, 2995000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4425451
lower_level__c, Bedroom(s),Full Bath(s),Garage,Street Entrance
mls_id__c, 423761112
main_level__c, Full Bath(s);Partial Bath(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Double Sinks;Soaking Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-08-04
original_price__c, 2995000
overall_days_on_market__c, -81664
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 826.21
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000coglmUAA
roof__c, Bitumen;Shingle;Foam
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 3625
size__c, 3625
pba__state_pb__c, CA
stories__c, 4
pba__street_pb__c, Mercato
subdist__c, Glen Park
ffd_name, 3 Mercato Court, San Francisco, CA, 94131
view__c, City;City Lights;Canyon
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1977
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530656648-1.jpg
