meta_query='key:subdist__c;value:Laguna Honda - Forest Hill Extension|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='216285' 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, 357 Ulloa Street, San Francisco, CA, 94127
ffd_mls_id, 510878
ffd_salesforce_id, a0E1I00000TlIulUAF
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 357 Ulloa Street, San Francisco, CA, 94127
pba__address_pb__c, 357 Ulloa Street, San Francisco, CA, 94127
agent_only_remarks__c, Offers are due on 12/24 by noon. Showings by appointment only. Please adhere to all showing guidelines: limit of 2 buyers & 1 agent. For showings, please schedule via Calendly (copy/paste): www.calendly.com/williamtransf/357-ulloa. A PEAD form must be provided 24 hrs before set appointment. For all questions, please contact William Tran at 650.759.5157 or Mike Duong at 415.990.1195. Disclosure packet is available via GLIDE: https://app.glide.com/share/5F7ItsRJhS8hNK9bpvMLnZ/ Thank you for showing!
appliances__c, Dishwasher;Gas Range;Refrigerator;Freestanding Range;Hood Over Range
bath_features__c, Tub w/Shower Over;Remodeled;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1924
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Mike Duong
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-12-16T02:46:12.000+0000
days_on_market__c, 946
dom__c, 14
ffd_description_pb, Nestled in the charming Forest Hill Extension just blocks from the beauty of Mt. Davis with its numerous trails & breathtaking views, this 2 bed, 1 bath oasis is a refuge waiting to be discovered. Welcomed by a beautiful facade adorning new landscaping and earthy terracotta roofing, the home welcomes you into its light-filled presence with open arms, ushering you into a tranquil open concept living & dining area boasting a charming fireplace & stunning refinished hardwood floors. For dining & entertainment, an elegantly reimagined kitchen features a suite of new SS appliances & stylish cabinetry. Beyond the kitchen is a sizable office that could double as an additional bedroom if needed. Completing this serene first floor are 2 spacious bedrooms, a hall closet & a tranquil bathroom. Beyond the pristine interior is a backyard showcasing fresh, low-maintenance landscaping complemented by a new fence & driveway. Situated close to West Portal, which has an abundance of eateries and shops.
357 Ulloa Street, San Francisco, CA, 94127 - Property Description
Nestled in the charming Forest Hill Extension just blocks from the beauty of Mt. Davis with its numerous trails & breathtaking views, this 2 bed, 1 bath oasis is a refuge waiting to be discovered. Welcomed by a beautiful facade adorning new landscaping and earthy terracotta roofing, the home welcomes you into its light-filled presence with open arms, ushering you into a tranquil open concept living & dining area boasting a charming fireplace & stunning refinished hardwood floors. For dining & entertainment, an elegantly reimagined kitchen features a suite of new SS appliances & stylish cabinetry. Beyond the kitchen is a sizable office that could double as an additional bedroom if needed. Completing this serene first floor are 2 spacious bedrooms, a hall closet & a tranquil bathroom. Beyond the pristine interior is a backyard showcasing fresh, low-maintenance landscaping complemented by a new fence & driveway. Situated close to West Portal, which has an abundance of eateries and shops.
