meta_query='key:subdist__c;value:Glen Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210447' 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
(
)
)
ffd_listing_title, 31 Fairmount Street, San Francisco, CA, 94131
ffd_mls_id, 496335
ffd_salesforce_id, a0E1I00000SOxxgUAD
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 31 Fairmount Street, San Francisco, CA, 94131
pba__address_pb__c, 31 Fairmount Street, San Francisco, CA, 94131
agent_only_remarks__c, Safe and easy virtual showings available 24 hours a day via 3D tour and video walk through! Website: www.31FairmountStreet.com Please contact Amy for disclosures or with any questions. Rear yard is private to 31 Fairmount only. Lot was split years ago into two SFRs. Home in rear of lot has Arlington address and is a separate property (but has utility easement). Thanks and stay well!
appliances__c, Dishwasher;Gas Range;Microwave;Refrigerator;Hood Over Range;Double Oven;Freezer;Built-In Oven
architectural_style__c, Contemporary;Modern/High Tech
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 2004
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Alec M Mironov
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-04-05T20:45:39.000+0000
days_on_market__c, 1200
dom__c, 11
ffd_description_pb, Gorgeous, airy and modern Fairmount Heights contemporary! Perched on the border of Glen Park and Noe Valley, this 16-years-young home offers current finishes, architectural details, and a calming neutral palate. Multiple outdoor living spaces flow from the open-concept great room. In front, a spacious and sunny deck. In the rear, a serene private garden w/fragrant trellised jasmine. The luxurious updated kitchen boasts acres of counter and prep space, pantry area and breakfast bar. 2BRs share a stylish remodeled BA and curved bay windows. Above it all, the master BR retreat soars and inspires w/ dramatic downtown skyline and Bay Bridge VIEWS, gorgeous en-suite bath, adjacent deck, skylights, and walk-in closet. Downstairs is an ultra-convenient and perfectly secluded au pair, guest suite or home office sanctuary. Garage w/ adjacent storage. All the peace of mind and convenience that a newer home affords. Virtual showings at: https://www.31fairmountstreet.com/unbranded
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant
ffd_lastmodifieddate, 2022-01-12T15:29:54.000+0000
pba__latitude_pb__c, 37.73885
pba__latitude_property__c, 37.73885
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2019-09-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Amy
pba__listing_agent_lastname__c, Clemens
listing_agent_mls_id__c, 802363
ffd_listingagentname, Amy Clemens
listing_agent_number__c, 802363
listing_co_agent_mls_id__c, 808044
listing_co_agent_number__c, 1030093
listing_co_office_mls_id__c, CGL01
listing_co_office_name__c, Corcoran Global Living
listing_co_office_number__c, 28273
listing_office_mls_id__c, CGL01
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28273
pba__listingprice_pb__c, 2100000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.31fairmountstreet.com?utm_source=mls-link&utm_medium=idx-feed&utm_campaign=idx
pba__longitude_pb__c, -122.42516
pba__lotsize_pb__c, 0.03
mls_id__c, 496335
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-04-05
original_price__c, 2100000
overall_days_on_market__c, 87
parking__c, Attached,Garage,Auto Door
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener,Side-by-Side,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Enclosed Patio;Deck(s);Patio(s)
pba__pendingdate__c, 2020-04-16
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1169.71
pba__propertytype__c, Single Family Residence
id, a0E1I00000SOxxgUAD
sale_date__c, 2020-05-13
sale_price__c, 2240000
security_features__c, Security Gate
selling_agent_mls_id__c, 400593
selling_agent_name__c, Ruth Krishnan
selling_agent_number__c, 1019790
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass SF
pba__status__c, Closed
pba__totalarea_pb__c, 1915
size__c, 1915
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Fairmount
subdist__c, Glen Park
ffd_name, 31 Fairmount Street, San Francisco, CA, 94131
view__c, City Lights;Downtown;Bay Bridge;San Francisco;Twin Peaks
website_property_type__c, Single Family Home
window_features__c, Dual Pane
pba__yearbuilt_pb__c, 2004
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/361874-1.jpg
ListingId, a0E1I00000SOxxgUAD