meta_query='key:subdist__c;value:Merced Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='425951' 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-11-14 13:15:57
[post_modified_gmt] => 2024-11-14 21:15:57
[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
(
)
)
_yoast_indexnow_last_ping, 1743038533
ffd_listing_title, 450 Bright Street, San Francisco, CA, 94132
ffd_mls_id, 425019711
ffd_salesforce_id, a0EUd000004ZA8hMAG
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
pba__address_pb__c, 450 Bright Street, San Francisco, CA, 94132
address2__c, 450 Bright Street, San Francisco, CA, 94132
agent_only_remarks__c, Offer date TBD agent will update those with disclosures. For disclosures please EMAIL [email protected] For questions, please text Samantha at 415-640-7602. Pre-sale escrow WFG National Title with Connie Choy. Seller reserves the right to accept, counter, or reject any offer. DO NOT rely on digital enhanced photos for lot lines, buyer to investigate to their satisfaction on lot size and potential of these homes/lots.
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2025-03-21T10:48:34.000+0000
days_on_market__c, 5
dom__c, 5
ffd_description_pb, Ever dreamed of building your own dream home? Here's your chance in one of San Francisco's most sought-after neighborhoods. This prime location is perfect for contractors and investors looking to bring their vision to life. Conveniently situated for commuters, this property is near Muni, BART, and offers easy access to Highway 280. Enjoy the close proximity to Stonestown Galleria Mall, grocery stores, shops, and the vibrant dining and services on Ocean Ave. Nearby amenities include Whole Foods, Trader Joe's, HMart, Philz Coffee, Lake Merced, San Francisco State University, Lowell High School, and multiple bus stops. This property is ideal for developers, contractors, and investors. The adjacent property at 454 Bright St is also available, offering additional potential for expansion or development. Don't miss this opportunity to create something truly special in a prime San Francisco location.
district__c, SF District 3
entry_level__c, 0
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2025-03-27T00:47:45.000+0000
pba__latitude_pb__c, 37.7188735
pba__latitude_property__c, 37.7188735
listed_date__c, 2025-03-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Samantha
pba__listing_agent_lastname__c, Huang
listing_agent_mls_id__c, 809630
ffd_listingagentname, Samantha J Huang
listing_agent_number__c, 1042187
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CIP13
listing_office_name__c, NEXTGEN Properties
listing_office_number__c, 29180
pba__listingprice_pb__c, 599888
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/J55C0gcqhEI
pba__longitude_pb__c, -122.4633837
mls_id__c, 425019711
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2025-03-21
open_house_end__c, 2025-03-29T16:00:00.000+0000
open_house_start__c, 2025-03-29T14:00:00.000+0000
original_price__c, 599888
overall_days_on_market__c, -82259
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 833.18
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000004ZA8hMAG
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 720
size__c, 720
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Bright
subdist__c, Merced Heights
ffd_name, 450 Bright Street, San Francisco, CA, 94132
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530960775-1.jpg