meta_query='key:subdist__c;value:Monterey Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='233746' 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, 250 Maywood Drive, San Francisco, CA, 94127
ffd_mls_id, 482030
ffd_salesforce_id, a0E1I000006bwzKUAQ
address2__c, 250 Maywood Drive, San Francisco, CA, 94127
pba__address_pb__c, 250 Maywood Drive, San Francisco, CA, 94127
agent_only_remarks__c, Offers due Friday, March 15 by 12 noon.
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1937
pba__city_pb__c, San Francisco
ffd_createddate, 2019-03-08T17:46:45.000+0000
days_on_market__c, 1595
dom__c, 11
ffd_description_pb, 4 amazing view bedrooms including 2 master en-suites, 3 remodeled bathrooms one with breathtaking views, remodeled panoramic view kitchen, view living room, view dining room, view family room, walk out view Trexdeck, lush green landscaped front garden and large back yard, big garage and excellent storage! Forced air heating for top 2 floors and radiant heat with 2 zones on lower level. Located on a prime block in one of SF's most coveted, upscale, quiet and pristine neighborhoods, on a large lot and offers a serene environment and majestic views. Built in 1937 and over 3000 Sq. Ft., it boasts beautiful architectural detail throughout, including high ceilings, hardwood floors, crown moldings, double-pane windows, custom recessed lighting, beautiful staircase and wonderful curb appeal. The excellent floor plan was designed and configured to embrace the views and offer family living at its best. One will be mesmerized by the extraordinary sunsets and enjoy the indoor/outdoor living.
district__c, SF District 4
external_listing__c, 1
hoa_dues__c, 0
ffd_lastmodifieddate, 2022-03-01T20:26:58.000+0000
pba__latitude_pb__c, 37.732262
pba__latitude_property__c, 37.732262
listed_date__c, 2018-11-26
pba__listing_agent_firstname__c, Robert
pba__listing_agent_lastname__c, Callan
listing_agent_mls_id__c, 804668
listing_agent_number__c, 166014312
listing_co_agent_mls_id__c, 215760
listing_co_agent_number__c, 215760
listing_co_office_mls_id__c, MCGU
listing_co_office_name__c, McGuire Real Estate
listing_co_office_number__c, 1497
listing_office_mls_id__c, MCGU
listing_office_name__c, McGuire Real Estate
listing_office_number__c, 1497
pba__listingprice_pb__c, 1995000
pba__listingtype__c, Sale
pba__listing_website__c, http://250maywooddrive.com/
pba__longitude_pb__c, -122.461960
pba__lotsize_pb__c, 0.1
mls_id__c, 482030
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2019-03-07
original_price__c, 1995000
overall_days_on_market__c, 1595
parking__c, Garage,Auto Door,Interior Access
parking_access__c, Side-by-Side
parking_type__c, On Site
price_per_square_foot__c, 907.74
pba__propertytype__c, Single-Family Home
id, a0E1I000006bwzKUAQ
sale_date__c, 2019-04-08
sale_price__c, 2755000
selling_agent_mls_id__c, 810732
selling_agent_name__c, Saba Shoaeioskouei
selling_agent_number__c, 1047664
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, 3035
size__c, 3035
pba__state_pb__c, CA
pba__street_pb__c, Maywood
subdist__c, Monterey Heights
ffd_name, 250 Maywood Drive, San Francisco, CA, 94127
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1937
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/347615-1.jpg
ListingId, a0E1I000006bwzKUAQ