meta_query='key:subdist__c;value:Merced Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214761' 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, 369 Ralston Street, San Francisco, CA, 94132
ffd_mls_id, 506101
ffd_salesforce_id, a0E1I00000THpyWUAT
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 369 Ralston Street, San Francisco, CA, 94132
pba__address_pb__c, 369 Ralston Street, San Francisco, CA, 94132
agent_only_remarks__c, Schedule showing through this link: https://calendly.com/pauline_realestate/369ralston and email signed PEAD prior to showing in exchange for combo lockbox. Please follow all SFAR showing guidelines. For faster response, please text Pauline at 415-867-1301 or email [email protected]. Escrow opened with First American, Silvia Barragan #6370457. Seller reserves right to accept, counter, & reject any offer, including preemptive offers.
appliances__c, Dishwasher;Disposal;Refrigerator
architectural_style__c, Contemporary;Spanish/Med
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1927
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-10-02
ffd_createddate, 2020-09-28T22:46:11.000+0000
days_on_market__c, 1024
dom__c, 24
ffd_description_pb, Fully detached Merced Heights home w/ million dollar views! Nestled minutes from SFSU, Stonestown and Merced Heights Playground, this property offers 4 beds, 3 baths, a spacious yard & an oversized deck- perfect place to demonstrate hospitality. Main level has 2 beds, living rm w/ wood burning fireplace, formal dining & a bkfst nook. You won't want to leave the light-filled en suite bedroom, which features a spa-inspired bathroom w/ a built-in bidet, enjoy the sunset from the west-facing deck to unwind your day. Garage level w/ separate entrance has 2 beds, 1 multi-purpose room, versatile floor plan to suit your lifestyle's constantly changing needs- from au-pair quarter, home office or media rm. There's also a laundry/ pantry rm, and an oversized deck for your outdoor BBQ. Steps to Brooks Park, Merced Heights Playground, basketball & tennis court. Look no further, Ralston is the perfect balanced lifestyle between living in the City & the suburbs.
district__c, SF District 3
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:34:24.000+0000
pba__latitude_pb__c, 37.7191339
pba__latitude_property__c, 37.7191339
laundry_features__c, Washer/Dryer Included
listed_date__c, 2020-09-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Pauline
pba__listing_agent_lastname__c, Ha
listing_agent_mls_id__c, 807388
ffd_listingagentname, Pauline W Ha
listing_agent_number__c, 1017144
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, EXPRE
listing_office_name__c, eXp Realty of California, Inc
listing_office_number__c, 26334
pba__listingprice_pb__c, 1190000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?brand=0&m=LQHPCCoQc8K
pba__longitude_pb__c, -122.4691947
pba__lotsize_pb__c, 0.08
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 506101
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-09-28
original_price__c, 1190000
overall_days_on_market__c, 167
parking__c, Attached
parking_access__c, Independent
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-10-22
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 841.41
pba__propertytype__c, Single Family Residence
id, a0E1I00000THpyWUAT
room_type__c, Storage;Office;Bonus Room;Laundry;In Law Apartment
sale_date__c, 2020-10-22
sale_price__c, 1581000
selling_agent_mls_id__c, 809136
selling_agent_name__c, Carlos L. Barrientos
selling_agent_number__c, 1040713
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Redfin
pba__status__c, Closed
pba__totalarea_pb__c, 1879
size__c, 1879
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Ralston
subdist__c, Merced Heights
ffd_name, 369 Ralston Street, San Francisco, CA, 94132
transportation__c, 1 Block
view__c, Ocean;City Lights;Water
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1927
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/370293-1.jpg
ListingId, a0E1I00000THpyWUAT