meta_query='key:subdist__c;value:Glen Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='395740' 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] => 2024-03-19 13:53:22
[post_modified_gmt] => 2024-03-19 20:53:22
[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
(
)
)
_yoast_indexnow_last_ping, 1726710932
ffd_listing_title, 3 Mercato Court, San Francisco, CA, 94131
ffd_mls_id, 424053110
ffd_salesforce_id, a0EUd0000036pJ4MAI
num_of_fireplaces__c, 0
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, Disclosures linked here: https://app.disclosures.io/link/3-Mercato-Court-l9a1v6q9 Property is part of a neighborhood HOA- dues are $450/year.
appliances__c, Disposal;Hood Over Range;Free Standing Gas Range
architectural_style__c, Contemporary
bath_features__c, None
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1977
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Colleen M Cotter
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2024-09-13T21:47:34.000+0000
days_on_market__c, 5
dom__c, 5
ffd_description_pb, 3 Mercato Court is a rare opportunity to own a beautifully renovated 4 bedroom + den, 2.5 bathroom home located in the heart of Glen Park. This fully detached residence is situated on a serene cul-de-sac and offers outstanding panoramic views of the surrounding hillscape and San Francisco Bay. The main level of this spacious 3,625 square foot residence boasts an open floor plan. The living area features a fireplace and a wall of windows that provide stunning views and plenty of natural light, and opens directly onto a large balcony where you can further enjoy jaw-dropping vistas. The luxury chef's kitchen features custom cabinets, stainless steel appliances, and sleek quartz countertops, while the adjoining dining area provides the ideal place to enjoy meals with friends and family. The large primary ensuite bedroom can also be found on this level, and is home to a large walk-in closet and a spa-like bathroom. An office and an additional half bathroom complete the main level. One level below, you will find two additional spacious bedrooms and a full luxurious bathroom, along with another large balcony facing the San Francisco hills. The top floor of this home is the perfect place to relax, as it is home to a large recreation room with a wet bar, perfect for entertaining.
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
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 450
pba__hoafrequency_pb__c, Annually
hoa_name__c, Mira Glen Homeowners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Cathedral Ceiling;Wet Bar
ffd_lastmodifieddate, 2024-09-19T01:47:09.000+0000
pba__latitude_pb__c, 37.7350861
pba__latitude_property__c, 37.7350861
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2024-07-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Frank
pba__listing_agent_lastname__c, Nolan
listing_agent_mls_id__c, 803037
ffd_listingagentname, Frank A Nolan
listing_agent_number__c, 803037
listing_co_agent_mls_id__c, 805388
listing_co_agent_number__c, 166015298
listing_co_office_mls_id__c, VANG06
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 25987
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 2600000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.3mercatocourt.com/
pba__longitude_pb__c, -122.4425643
lower_level__c, Bedroom(s),Full Bath(s),Garage,Street Entrance
mls_id__c, 424053110
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, 2024-09-13
open_house_end__c, 2024-09-18T18:30:00.000+0000
open_house_start__c, 2024-09-18T17:00:00.000+0000
original_price__c, 2600000
overall_days_on_market__c, -82070
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-09-13T14:02:55.000+0000
price_per_square_foot__c, 704.61
pba__propertytype__c, Single Family Residence
ListingId, a0EUd0000036pJ4MAI
room_type__c, Living Room;Primary Bathroom;Primary Bedroom
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, 3690
size__c, 3690
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Mercato
subdist__c, Glen Park
ffd_name, 3 Mercato Court, San Francisco, CA, 94131
view__c, City;Downtown;Hills;Canyon
website_property_type__c, Single Family Home
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/530828618-1.jpg