meta_query='key:subdist__c;value:Laguna Honda - Forest Hill Extension|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214634' 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, 452 Ulloa Street, San Francisco, CA, 94127
ffd_mls_id, 505591
ffd_salesforce_id, a0E1I00000THhIbUAL
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 452 Ulloa Street, San Francisco, CA, 94127
pba__address_pb__c, 452 Ulloa Street, San Francisco, CA, 94127
agent_only_remarks__c, Offers due Thursday 9/24 at 10:00 AM. Use SFAR Purchase Contract only. Stipulate in Purchase Contract that buyer's initial deposit to be in escrow within one business day of acceptance. Escrow opened with First American Title, Liz Paglinawan 415-682-1112. 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.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Hood Over Range
architectural_style__c, Contemporary;Craftsman
bath_features__c, Remodeled;Marble;Tile
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1957
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-09-24
ffd_createddate, 2020-09-10T16:46:33.000+0000
days_on_market__c, 1042
dom__c, 28
ffd_description_pb, Exquisite Mid-Century Modern view home tucked away on great block & huge lot w/side yard, close to West Portal Village! Landscaped garden entrance leads to notable milk-glass front door & into gracious foyer. Handsome formal living rm boasts fireplace w/colorful tile surround, recessed lighting, hardwood floors & large picture window w/views to Mt Davidson. Spacious, light-filled dining rm w/sliding glass door to walk-out deck! Beautifully remodeled gourmet kitchen showcases all stainless-steel appliances incl gas range, corner sink w/views to the garden, Corian counters w/subway tile backsplash & custom wood cabinets. 3BR/2BA up incl terrific en-suite w/walk-in closet, impressive private bath & views of hills & trees. Amazing lower level master suite retreat/4th BR or family rm w/extraordinary walk-in closet, comfortable sitting rm & stunning remodeled Carrara marble & tile bath w/built-in vanity. Spectacular backyard w/bucolic hillside, side yd lawn & expansive deck for entertaining!
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
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:33:52.000+0000
pba__latitude_pb__c, 37.7412234
pba__latitude_property__c, 37.7412234
laundry_features__c, Washer/Dryer Included
listed_date__c, 2020-09-10
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, 1795000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.andrewherrera.com/
pba__longitude_pb__c, -122.4588677
pba__lotsize_pb__c, 0.15
lower_level__c, Family Room,Full Bath(s)
mls_id__c, 505591
main_level__c, Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-09-10
original_price__c, 1795000
overall_days_on_market__c, 181
parking__c, Attached,Garage,Auto Door,Interior Access
parking_features__c, Attached,Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-10-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 981.06
pba__propertytype__c, Single Family Residence
id, a0E1I00000THhIbUAL
room_type__c, Den
sale_date__c, 2020-10-22
sale_price__c, 2020000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 808044
selling_agent_name__c, Alec L. Mironov
selling_agent_number__c, 1030093
selling_co_agent_mls_id__c, 802363
selling_co_agent_name__c, Amy C. Clemens
selling_co_agent_number__c, 802363
selling_co_office_mls_id__c, CGL01
selling_co_office_name__c, Corcoran Global Living
selling_co_office_number__c, 28273
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 2059
size__c, 2059
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Ulloa
subdist__c, Laguna Honda - Forest Hill Extension
ffd_name, 452 Ulloa Street, San Francisco, CA, 94127
view__c, Ocean;Panoramic;City Lights;Partial;Water;Hills;Mountains;Forest
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1957
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/369959-1.jpg
ListingId, a0E1I00000THhIbUAL