meta_query='key:subdist__c;value:Laguna Honda - Forest Hill Extension|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='222340' 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, 421618623
ffd_salesforce_id, a0E8W00000V2xDbUAJ
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 to Alec Mironov on Monday 1/24 @ 3pm. Call Alec Mironov for more information. No pre-emptive offers, per seller instruction. Square footage per previous MLS record, buyer to verify. Escrow with Nate Scharton ORTC.
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Gas Range
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1957
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Amy Clemens
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-01-13T16:46:37.000+0000
days_on_market__c, 552
dom__c, 11
ffd_description_pb, Who says you can't have it all? Steps from West Portal Village with a commanding 70+ ft of frontage, this mid-century beauty is located on a peaceful block and is ideal for the buyer that wants something *done*. Skip the Home Depot trips - just light the fireplace and relax! Upgrades and thoughtful touches are found throughout, along with chic modern finishes, clean lines, and a sophisticated neutral color palette. The A+ floor plan features an open flow plus 3BR/2BA on the upper level, including one with an en-suite bath and walk-in closet. Downstairs makes an ideal guest retreat, family room, or deluxe primary suite. On this level there's room for a king size bed plus a sitting area, luxurious full bathroom, and walk-in closet with custom built-ins. Edgehill Mountain open space lends both privacy and vibrancy. Just outside the kitchen window, hot pink vining flowers climb a beautiful rock formation, creating a lovely, lush outlook.
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Fenced;Front Yard
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Natural Gas
ffd_lastmodifieddate, 2022-02-16T01:46:30.000+0000
pba__latitude_pb__c, 37.7412234
pba__latitude_property__c, 37.7412234
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2021-11-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Alec
pba__listing_agent_lastname__c, Mironov
listing_agent_mls_id__c, 808044
ffd_listingagentname, Alec M Mironov
listing_agent_number__c, 1030093
listing_co_agent_mls_id__c, 802363
listing_co_agent_number__c, 802363
listing_co_office_mls_id__c, PACEDGE
listing_co_office_name__c, Pacific Edge
listing_co_office_number__c, 28507
listing_office_mls_id__c, PACEDGE
listing_office_name__c, Pacific Edge
listing_office_number__c, 28507
pba__listingprice_pb__c, 1995000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.452ulloa.com/
pba__longitude_pb__c, -122.4588677
lower_level__c, Master Bedroom,Garage,Full Bath(s)
mls_id__c, 421618623
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-01-13
original_price__c, 1995000
overall_days_on_market__c, 77
parking_access__c, Independent
parking_features__c, Garage Door Opener,Attached
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Back Porch;Enclosed Patio
pba__pendingdate__c, 2022-01-24
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-02-15T09:26:42.000+0000
price_per_square_foot__c, 1337.72
pba__propertytype__c, Single Family Residence
id, a0E8W00000V2xDbUAJ
room_type__c, Master Bedroom
sale_date__c, 2022-02-14
sale_price__c, 2754375
selling_agent_mls_id__c, 806718
selling_agent_number__c, 166017501
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Brava Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 2059
size__c, 2059
pba__state_pb__c, CA
stories__c, 2
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;San Francisco;Hills;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/530385425-1.jpg
ListingId, a0E8W00000V2xDbUAJ