meta_query='key:subdist__c;value:Laguna Honda - Forest Hill Extension|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214473' posts_per_page=4 post_type=property
int(1)
Array
(
[ID] => 12142
[post_author] => 4
[post_date] => 2018-10-29 01:14:20
[post_date_gmt] => 2018-10-29 01:14:20
[post_content] => Across the street from Forest Hill. Or Laguna Honda. Or Tower Market. Home to the delightfully hidden Rockridge Terrace. And beautiful homes on nicely sized lots that don't get the respect they deserve. Thanks, neighbors.
[post_title] => Forest Hill Extension
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => forest-hill-extension
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 09:12:40
[post_modified_gmt] => 2024-03-19 16:12:40
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12142
[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, 129 Merced Avenue, San Francisco, CA, 94127
ffd_mls_id, 504989
ffd_salesforce_id, a0E1I00000TGDGRUA5
num_of_fireplaces__c, 2
num_of_rooms__c, 0
of_units__c, 0
address2__c, 129 Merced Avenue, San Francisco, CA, 94127
pba__address_pb__c, 129 Merced Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Offer date Wednesday 9/16 at 12 noon. Do Not Send Text Messages, please email for all showing requests. Property is being marketed under Covid19 guidelines. Buyer's agent must provide a pre-approval letter or POF and a signed PEAD-V before viewing home. All visitors must wear masks & use hand sanitizer. 3D Tour available on the MLS, just click on visual media. Go to the last photo to view marketing brochure for additional property details and floor plans. Please use the SFAR Purchase Contract only & stipulate in the contract that buyer's initial deposit to be in escrow within one business day of acceptance of offer. Escrow opened with First American Title, Liz Paglinawan 415-682-1112.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Hood Over Range;Double Oven
architectural_style__c, Traditional;French
bath_features__c, Shower Stall(s);Tub;Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1926
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-09-03T16:46:27.000+0000
days_on_market__c, 1049
dom__c, 13
ffd_description_pb, Grand French Mediterranean view home proudly situated on corner lot! Garden entrance w/mature palm trees leads to impressive landing w/arched French doors & into a remarkable foyer w/stunning 'Hollywood-style' spiral staircase. Dramatic formal living rm w/vaulted barrel ceiling boasts frpl w/marble surround, floor to ceiling picture windows & inlaid hardwood flrs. Gorgeous ten-sided banquet-size formal dining rm! Fabulous gourmet kitchen w/huge breakfast rm features all stainless-steel appliances incl Thermador gas range, custom wood cabinets, granite counters w/pass-thru, walk-in pantry & servant's entrance. Expansive 'hotel-like' hallway adjoins a terrific den/cigar lounge, solarium & magnificent master bedrm w/notable sitting rm, amazing walk-in closet & huge bath w/sep shower & tub. Spectacular ballroom/family rm w/frpl, walk-in closet w/secret prohibition cellar, Tiki Bar/3rd BR w/bar, stools & amazing walk-out roof deck. Delightful landscaped backyard w/patio, koi pond & hot tub!
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Wood Burning;Gas Piped;Family Room
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:33:13.000+0000
pba__latitude_pb__c, 37.744299
pba__latitude_property__c, 37.744299
laundry_features__c, Inside Room;Washer/Dryer Included
listed_date__c, 2020-09-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Andrew
pba__listing_agent_lastname__c, Herrera II
listing_agent_mls_id__c, 404547
ffd_listingagentname, Andrew Herrera II
listing_agent_number__c, 404547
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, BHFP
listing_office_name__c, Berkshire Hathaway-Franciscan
listing_office_number__c, 1665
pba__listingprice_pb__c, 2695000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.andrewherrera.com/
pba__longitude_pb__c, -122.461358
pba__lotsize_pb__c, 0.12
lower_level__c, Partial Bath(s)
mls_id__c, 504989
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2020-09-03
original_price__c, 2695000
overall_days_on_market__c, 181
parking__c, Attached,Garage,Auto Door,Interior Access,Guest Space(s)
parking_features__c, Attached,Garage Door Opener,Guest Parking Available,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s);Patio(s)
pba__pendingdate__c, 2020-09-16
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 788.9
pba__propertytype__c, Single Family Residence
id, a0E1I00000TGDGRUA5
room_type__c, Storage;Sun Room;Laundry;Den;Solarium
sale_date__c, 2020-10-08
sale_price__c, 2900000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 803964
selling_agent_name__c, Trecia Knapp
selling_agent_number__c, 166013343
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 3676
size__c, 3676
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Merced
subdist__c, Laguna Honda - Forest Hill Extension
ffd_name, 129 Merced Avenue, San Francisco, CA, 94127
view__c, Ocean;Panoramic;City Lights;Garden/Greenbelt;Partial;Water;Hills;Forest
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1926
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/369534-1.jpg
ListingId, a0E1I00000TGDGRUA5