meta_query='key:subdist__c;value:Forest Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='330746' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12152
[post_author] => 4
[post_date] => 2018-10-29 01:18:51
[post_date_gmt] => 2018-10-29 01:18:51
[post_content] => Adolph Sutro once owned all the land in Forest Hill, which his heirs sold to developers early in the 20th century. The first home in the neighborhood was sold in 1914, and it’s a safe bet that other than more mature trees and fancier cars in the garages, this stately neighborhood looks much the same as it did 100+ years ago.
[post_title] => Forest Hill
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => forest-hill
[to_ping] =>
[pinged] =>
[post_modified] => 2018-10-29 01:18:51
[post_modified_gmt] => 2018-10-29 01:18:51
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12152
[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, 55 Mendosa Avenue, San Francisco, CA, 94116
ffd_mls_id, 423717349
ffd_salesforce_id, a0E8W00000ban7UUAQ
num_of_fireplaces__c, 2
num_of_rooms__c, 10
of_units__c, 0
address2__c, 55 Mendosa Avenue, San Francisco, CA, 94116
pba__address_pb__c, 55 Mendosa Avenue, San Francisco, CA, 94116
agent_only_remarks__c, Please DO NOT text for showings. *Please use Calendly https://calendly.com/helena7x7/55-mendosa-showing-schedule Pre-escrow opened with Kallie Castro at First American Title [email protected]) Disclosures: https://app.disclosures.io/link/55-Mendosa-Avenue-qzucfrrp Offer date to be set after the second weekend of opens - date & instructions will be shared via Disclsoures.Io. All buyers to use the most current 8-page SFAR contract. If needed, one will be provided. *All info herein is not guaranteed. Prospective purchasers are advised to independently verify accuracy and to review any disclosure information before submitting offers.*
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Oven;Other
architectural_style__c, Traditional
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 5
year_build_text__c, 1952
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-04-06T18:48:32.000+0000
days_on_market__c, 26
dom__c, 14
ffd_description_pb, Experience urban sophistication at its finest in this stunning 3-story residence situated in the prestigious Forest Hill neighborhood of San Francisco. With over 3,200 sq ft of luxurious living space, this home features 5 spacious bedrooms and 4 well-appointed bathrooms. Upon entering the property, you'll be greeted by a warm two-sided fireplace, stunning ceiling beams, and an open-concept grand dining room and kitchen area, perfect for entertaining. The high ceilings and floor-to-ceiling windows provide ample natural light, highlighting the beautiful hardwood floors. The kitchen is fully equipped with top-of-the-line appliances and ample counter space. Upstairs, four bedrooms and a media room offer stunning views of the city. Each bedroom is spacious and features large windows, ample closet space, and hardwood floors for added style. The primary suite is a true retreat, featuring magnificent views, a spa-like bathroom, and a balcony. The property also includes a guest bedroom on the lower level, playroom, and gym. With breathtaking views of the city and easy walkability to shopping, dining & transport, 55 Mendosa is the epitome of urban living. Don't miss the opportunity to own this special, turn-key property in one of San Francisco's most desirable neighborhoods
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Brick;Gas Piped;Dining Room;Double Sided
pba__floortype_pb__c, Carpet;Tile;Wood;Stone
pba__hoafees__c, 850
pba__hoafrequency_pb__c, Annually
hoa_name__c, Forest Hill Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Fireplace(s)
interior_features__c, Open Beam Ceiling
ffd_lastmodifieddate, 2023-05-02T00:49:42.000+0000
pba__latitude_pb__c, 37.74842
pba__latitude_property__c, 37.74842
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included;Upper Floor
listed_date__c, 2023-01-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Helena
pba__listing_agent_lastname__c, Zaludova
listing_agent_mls_id__c, 804652
ffd_listingagentname, Helena Zaludova
listing_agent_number__c, 166014293
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 3500000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.helena7x7.com/properties/55-mendosa-avenue/
pba__longitude_pb__c, -122.465517
lower_level__c, Bedroom(s),Full Bath(s),Garage,Living Room
mls_id__c, 423717349
main_level__c, Kitchen;Living Room;Dining Room;Family Room;Street Entrance
master_bathroom_features__c, Double Sinks;Soaking Tub;Window;Multiple Shower Heads
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-04-06
original_price__c, 3500000
overall_days_on_market__c, -81544
parking_access__c, Independent
parking_features__c, Garage Door Opener,Garage Facing Front
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-04-20
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-05-01T11:17:28.000+0000
price_per_square_foot__c, 1123.24
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000ban7UUAQ
room_type__c, Kitchen;Library;Living Room;Game Room;Family Room;Media Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2023-05-01
sale_price__c, 3600000
selling_agent_mls_id__c, 400593
selling_agent_number__c, 1019790
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, 3205
size__c, 3205
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Mendosa
subdist__c, Forest Hill
ffd_name, 55 Mendosa Avenue, San Francisco, CA, 94116
view__c, City;Bay;San Francisco;Golden Gate Bridge;Twin Peaks;Hills
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1952
pba__postalcode_pb__c, 94116
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530577743-1.jpg