meta_query='key:subdist__c;value:Merced Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='234392' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12156
[post_author] => 4
[post_date] => 2018-10-29 01:19:06
[post_date_gmt] => 2018-10-29 01:19:06
[post_content] => A tiny neighborhood, just two blocks by 12 blocks in size. But pay attention to the “Heights” in the name -- that altitude creates views for days. It’s strictly residential, with not even a corner store in the mix.
[post_title] => Merced Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => merced-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 10:03:55
[post_modified_gmt] => 2024-03-19 17:03:55
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12156
[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, 415 Shields Street, San Francisco, CA, 94132
ffd_mls_id, 489188
ffd_salesforce_id, a0E1I00000H12teUAB
address2__c, 415 Shields Street, San Francisco, CA, 94132
pba__address_pb__c, 415 Shields Street, San Francisco, CA, 94132
agent_only_remarks__c, Single Family Dwelling at condo pricing! Owner occupied. Please contact listing agent for showings. www.415shieldsstreet.com Offers welcome Tuesday 9/24 by 6:00 p.m. Contact agent for Disclosure Packet. Please use SFAR Purchase Contract.
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1940
pba__city_pb__c, San Francisco
ffd_createddate, 2019-09-13T17:46:37.000+0000
days_on_market__c, 1405
dom__c, 24
ffd_description_pb, Charming Two Bedroom, One Bath Art Deco home with ocean and Mt. Tam views! Front windows are new, Bathroom is remodeled! Terraced Back Yard backs up to Brooks Park and upper terrace has a 10 x 10 structure from which to enjoy the wonderful views! Patio off back bedrooms offers both privacy and protection from ocean breezes. Lower level has several bonus areas currently used for office and work out space! Nearby Ocean Avenue offers Whole Foods, Philz Coffee & many other cafes and shops. The Apple Store, Trader Joes, Target, Nordstrom, Movie Theaters and assorted enticing eateries can be found at Stonestown Galleria Mall. Easy access to freeway!
district__c, SF District 3
external_listing__c, 1
hoa_dues__c, 0
ffd_lastmodifieddate, 2022-03-01T20:30:30.000+0000
pba__latitude_pb__c, 37.717737
pba__latitude_property__c, 37.717737
listed_date__c, 2019-09-03
pba__listing_agent_firstname__c, Nana
pba__listing_agent_lastname__c, Meyer
listing_agent_mls_id__c, 271100
listing_agent_number__c, 271100
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 27690
pba__listingprice_pb__c, 839000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4665605
pba__lotsize_pb__c, 0.06
mls_id__c, 489188
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2019-09-13
original_price__c, 839000
overall_days_on_market__c, 1405
parking__c, Attached,Garage,Auto Door,Interior Access
parking_type__c, On Site
price_per_square_foot__c, 980.95
pba__propertytype__c, Single-Family Home
id, a0E1I00000H12teUAB
sale_date__c, 2019-10-16
sale_price__c, 1030000
selling_agent_mls_id__c, 811230
selling_agent_name__c, Robert B. Collett
selling_agent_number__c, 1050607
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Berkshire Hathaway Drysdale Properties
pba__status__c, Closed
pba__totalarea_pb__c, 1050
size__c, 1050
pba__state_pb__c, CA
pba__street_pb__c, Shields
subdist__c, Merced Heights
ffd_name, 415 Shields Street, San Francisco, CA, 94132
transportation__c, 4+ Blocks
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1940
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/355779-1.jpg
ListingId, a0E1I00000H12teUAB