meta_query='key:subdist__c;value:Glen Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='385886' 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, 1726361596
ffd_listing_title, 172 Fairmount Street, San Francisco, CA, 94131
ffd_mls_id, 424060535
ffd_salesforce_id, a0EUd0000033DYVMA2
num_of_fireplaces__c, 1
num_of_rooms__c, 4
of_units__c, 2
address2__c, 172 Fairmount Street, San Francisco, CA, 94131
pba__address_pb__c, 172 Fairmount Street, San Francisco, CA, 94131
agent_only_remarks__c, Lives like a single-family home with exclusive use front patio. Super cute, lives bigger than 747 sq ft per tax records. 2-homes on 1-lot comprise 2-unit Condo HOA, condo converted in ~2005. 172 Fairmount is in front, with 170 Fairmount in rear separated by a Common Area garden. Parking is uncovered tandem on parking pad on side of home. Rear home is owner occupied. Super easy to show, text/call Mary Ann 415-999-1200. Tax records default to 2 bed/1 bath, appears to be a 1-bed w/ flex space, buyer to investigate to satisfaction. **OFFERS if any, welcome on Monday September 16th by 2pm.**
appliances__c, Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Cottage;Bungalow
bath_features__c, Shower Stall(s);Low-Flow Toilet(s);Bidet;Low-Flow Shower(s)
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1926
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Naomi Lempert Lopez
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-09-06T20:48:41.000+0000
days_on_market__c, 8
dom__c, 8
ffd_description_pb, Didn't think you could find a home amongst the giants of Fairmount Heights? We've got you covered with this easy breezy standalone bungalow. Fully detached and drenched in light, this joyful gem has everything...move-in condition, remodeled bath and kitchen, office/guest space, 2-outdoor spaces, in-unit W/D, tons of storage, parking and so much curb appeal! Behind the modern gate, a private lush patio takes advantage of Glen Park's amazing microclimate. A charming side porch leads into the bright bungalow with hardwood throughout. The open concept living, dining and kitchen is the heart of the home. The remodeled kitchen with designer appliances add a pop of fun to the kitchen along with a laundry station with folding counter and full-size W/D, gas range and a pantry! The bedroom is bright and generous with high ceilings bathed in southern light. A nice sized flex space ideal for a home office or guest space and a cheery bathroom with a walk-in shower and lux bidet complete this special home. Access to the common area garden is off the back of the home. 1-car parking and extra storage. Sanchez and Arlington Slow Streets, Muni, Tech Shuttles, Glen Park BART and HWY 280 nearby. Part of a Condo HOA comprised of 2 detached homes (condos) on 1-lot with 172 in the premier front spot!
district__c, SF District 5
entry_level__c, 0
exterior_features__c, Uncovered Courtyard;Fire Pit
external_listing__c, 1
fencing__c, Wood
fireplace_features__c, Living Room;Free Standing
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Common Areas,Insurance,Water
pba__hoafees__c, 167
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 170 - 172 Fairmount
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Fireplace(s)
ffd_lastmodifieddate, 2024-09-15T00:46:23.000+0000
pba__latitude_pb__c, 37.7390737
pba__latitude_property__c, 37.7390737
laundry_features__c, In Kitchen;Washer Included;Dryer Included
listed_date__c, 2024-07-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mary Ann
pba__listing_agent_lastname__c, Montano
listing_agent_mls_id__c, 808878
ffd_listingagentname, Mary Ann Montano
listing_agent_number__c, 1038181
listing_co_agent_mls_id__c, 800407
listing_co_agent_number__c, 800407
listing_co_office_mls_id__c, CBLUXURY
listing_co_office_name__c, Coldwell Banker Realty
listing_co_office_number__c, 2128
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 699000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.cbhometour.com/172-Fairmount-St-San-Francisco-CA-94131/mlsindex.html
pba__longitude_pb__c, -122.4269608
mls_id__c, 424060535
master_property__c, a0OUd00000BjlxTMAR
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-09-06
open_house_end__c, 2024-09-14T13:00:00.000+0000
open_house_start__c, 2024-09-14T11:00:00.000+0000
original_price__c, 699000
overall_days_on_market__c, -82063
parking_access__c, Tandem
parking_features__c, Assigned,Uncovered Parking Space
parking_type__c, On Site - Unassigned (Condo Only)
patio_and_porch_features__c, Uncovered Patio;Front Porch
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, 935.74
pba__propertytype__c, Condominium
ListingId, a0EUd0000033DYVMA2
room_type__c, Office;Den;Kitchen;Living Room;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector
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, 747
size__c, 747
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Fairmount
subdist__c, Glen Park
ffd_name, 172 Fairmount Street, San Francisco, CA, 94131
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1926
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530834512-1.jpg