meta_query='key:subdist__c;value:Monterey Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='220509' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70666
[post_author] => 4
[post_date] => 2018-11-30 20:30:41
[post_date_gmt] => 2018-11-30 20:30:41
[post_content] => While you may have never heard of this neighborhood, you'll realize the name perfectly describes it: North of Monterey on a hill with views to the Pacific Ocean. Nestled between St. Francis Wood, Sherwood Forest, and Westwood Highlands lies a collection of stately single-family homes.
[post_title] => Monterey Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => monterey-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2023-10-30 17:00:50
[post_modified_gmt] => 2023-10-31 00:00:50
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70666
[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, 228 Yerba Buena Avenue, San Francisco, CA, 94127
ffd_mls_id, 421587319
ffd_salesforce_id, a0E1I00000UWB7YUAX
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 228 Yerba Buena Avenue, San Francisco, CA, 94127
pba__address_pb__c, 228 Yerba Buena Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Please use Showing Time to schedule all private showings. If you encounter any booking issues, call/text Kathy White at 415-595-9470. Please use SFAR purchase agreement. Pre-escrow opened with Kathie Ng, North American Title, [email protected]; Escrow #54605-21-03459. Disclosures available on Disclosures.IO or you can copy and paste this link in a browser: https://app.disclosures.io/link/228-Yerba-Buena-Avenue-gq5dgeoa
appliances__c, Dishwasher;Hood Over Range;Built-In Gas Range;Double Oven;Built-In Refrigerator
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1927
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-08-20T22:49:33.000+0000
days_on_market__c, 698
dom__c, 21
ffd_description_pb, Handsome Mediterranean-inspired home features beautiful old world charm w/fresh updating & great floor plan. Herringbone style hardwood floors & wood trim accents grace the main level. Inviting living room w/original tile surround fireplace, French windows, barrel ceiling. Beautiful archways with built-in cabinetry take you down the center hallway. Gorgeous dining room features double custom doors that open to main level patio garden. Remodeled kitchen features gourmet Paul Bocuse gas stove w/double oven, custom cabinets and pantry. En-suite bedroom w/private bath overlooks garden. Newly renovated 2nd full bath off hall. 2nd bedroom completes this level. Lower level features bonus room/ofc & wine cellar, 2 car garage, lots of addt'l storage space. Spectacular landscaped backyard w/deck & fountain, front yard w/lush new lawn. Open houses for Sept. 11/12 canceled
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Wood
pba__hoafees__c, 27
pba__hoafrequency_pb__c, Annually
hoa_name__c, Monterey Heights Homes Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
ffd_lastmodifieddate, 2022-01-25T15:59:32.000+0000
pba__latitude_pb__c, 37.7346473
pba__latitude_property__c, 37.7346473
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2021-07-21
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Paul
pba__listing_agent_lastname__c, Barbagelata
listing_agent_mls_id__c, 342615
ffd_listingagentname, Paul Barbagelata
listing_agent_number__c, 342615
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, BARBCO
listing_office_name__c, BarbCo
listing_office_number__c, 28297
pba__listingprice_pb__c, 1698000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=r9ME8n3Gp4H&mls=1
pba__longitude_pb__c, -122.460172
mls_id__c, 421587319
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-08-20
original_price__c, 1698000
overall_days_on_market__c, 93
parking_access__c, Tandem
parking_features__c, Enclosed,Garage Door Opener
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-09-10
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1153.19
pba__propertytype__c, Single Family Residence
id, a0E1I00000UWB7YUAX
sale_date__c, 2021-10-01
sale_price__c, 1882000
selling_agent_mls_id__c, 804686
selling_agent_number__c, 166014335
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass SF
pba__status__c, Closed
pba__totalarea_pb__c, 1632
size__c, 1632
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Yerba Buena
subdist__c, Monterey Heights
ffd_name, 228 Yerba Buena Avenue, San Francisco, CA, 94127
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1927
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530308494-1.jpg
ListingId, a0E1I00000UWB7YUAX