meta_query='key:subdist__c;value:Monterey Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='223093' 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, 59 Rosewood Drive, San Francisco, CA, 94127
ffd_mls_id, 485510
ffd_salesforce_id, a0E1I0000085RCXUA2
address2__c, 59 Rosewood Drive, San Francisco, CA, 94127
pba__address_pb__c, 59 Rosewood Drive, San Francisco, CA, 94127
agent_only_remarks__c, Offers due Friday 6/7/2019 by 10m.
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1927
pba__city_pb__c, San Francisco
ffd_createddate, 2019-05-31T16:47:08.000+0000
days_on_market__c, 1510
dom__c, 7
ffd_description_pb, Opportunity to create your dream home! A beautiful fixer on a great block in prime Monterey Heights!!! Fabulous bay and city views, lovely architectural details including parquet floors, hardwood floors throughout, vintage light fixtures, large formal living room with lovely fireplace, elegant formal dining room, plaster moldings, high ceilings, and great floor plan with approximately 2,395 square feet.
district__c, SF District 4
external_listing__c, 1
hoa_dues__c, 0
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2022-03-01T19:25:40.000+0000
pba__latitude_pb__c, 0.000000
pba__latitude_property__c, 0.000000
listed_date__c, 2019-05-01
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, 1585000
pba__listingtype__c, Sale
pba__listing_website__c, http://59rosewood.com/
pba__longitude_pb__c, 0.000000
pba__lotsize_pb__c, 0.1
mls_id__c, 485510
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2019-05-31
original_price__c, 1585000
overall_days_on_market__c, 1510
parking__c, Garage,Auto Door,Interior Access
parking_type__c, On Site
price_per_square_foot__c, 793.32
pba__propertytype__c, Single-Family Home
id, a0E1I0000085RCXUA2
sale_date__c, 2019-06-27
sale_price__c, 1900000
selling_agent_mls_id__c, 038605
selling_agent_name__c, George M. Green
selling_agent_number__c, 38605
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, GM Green Real Estate, Inc.
pba__status__c, Closed
pba__totalarea_pb__c, 2395
size__c, 2395
pba__state_pb__c, CA
pba__street_pb__c, Rosewood
subdist__c, Monterey Heights
ffd_name, 59 Rosewood Drive, San Francisco, CA, 94127
transportation__c, 2 Blocks
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/351897-1.jpg
ListingId, a0E1I0000085RCXUA2