meta_query='key:subdist__c;value:Merced Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='330462' 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] => 2018-10-29 01:19:06
[post_modified_gmt] => 2018-10-29 01:19:06
[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, 347 Ralston Street, San Francisco, CA, 94132
ffd_mls_id, 423731411
ffd_salesforce_id, a0E8W00000baYE6UAM
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 347 Ralston Street, San Francisco, CA, 94132
pba__address_pb__c, 347 Ralston Street, San Francisco, CA, 94132
agent_only_remarks__c, Vacant w/ Supra lockbox. Please leave business card. Square footage doesn't include lower rooms. Disclosure link available upon e-mail request. Please call listing agent with any questions. Pre escrow has been opened with Mary Ann Bunnell, DOMA Title of California (formerly known as North American Title Company), 689 Portola Drive, San Francisco, CA 94127. Please reach out with any questions relative to title or escrow matters at [email protected]
appliances__c, Dishwasher;Gas Water Heater;Disposal;Hood Over Range;Free Standing Refrigerator;Built-In Electric Range
architectural_style__c, Traditional
bath_features__c, Shower Stall(s);Tile;Multiple Shower Heads
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1928
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-04-01T18:47:57.000+0000
days_on_market__c, 33
dom__c, 4
ffd_description_pb, Classic 1928 Merced Heights view home. Upper-level features rich original hardwood floors and built-ins, formal living and dining rooms, updated kitchen and bathroom with radiant floor heating and walk-in shower with multiple shower heads, and 2 spacious bedrooms with expansive coastal views. Lower-level features bonus rooms with views, separate entrance, and spacious rear yard. The many upgrades include seismic bracing, updated electrical and plumbing, newer furnace & water heater, double-pane windows, and rear vinyl siding. The 1 car garage includes laundry area, workshop area, and storage. Great location near Stonestown Galleria, Trader Joe's and Whole Foods, Ocean Ave cafes and shops. Easy access to 280 Freeway, Bart and Muni Metro Lines.
district__c, SF District 3
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
electric__c, 220 Volts
entry_level__c, 0
external_listing__c, 1
fencing__c, Wood
fireplace_features__c, Living Room;Wood Burning;Brick
pba__floortype_pb__c, Tile;Vinyl;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Natural Gas
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2023-05-03T23:55:39.000+0000
pba__latitude_pb__c, 37.7187536
pba__latitude_property__c, 37.7187536
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2023-04-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Patrick
pba__listing_agent_lastname__c, Shannon
listing_agent_mls_id__c, 229293
ffd_listingagentname, Patrick H Shannon
listing_agent_number__c, 229293
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, TRIN
listing_office_name__c, Trinity Realty, Inc.
listing_office_number__c, 2129
pba__listingprice_pb__c, 1288888
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4692081
lower_level__c, Family Room,Full Bath(s),Garage,Street Entrance
mls_id__c, 423731411
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-04-01
original_price__c, 1288888
overall_days_on_market__c, -81539
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2023-04-05
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1228.07
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000baYE6UAM
road_surface_type__c, Paved
roof__c, Tar/Gravel
room_type__c, Bonus Room;Living Room;Dining Room
sale_date__c, 2023-04-26
sale_price__c, 1400000
security_features__c, Smoke Detector;Carbon Mon Detector;Double Strapped Water Heater
selling_agent_mls_id__c, 802851
selling_agent_number__c, 802851
selling_co_agent_mls_id__c, 808252
selling_co_agent_number__c, 1032461
selling_co_office_mls_id__c, INDIGO
selling_co_office_name__c, Indigo Real Estate
selling_co_office_number__c, 28648
selling_office_name__c, Indigo Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1140
size__c, 1140
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Ralston
subdist__c, Merced Heights
ffd_name, 347 Ralston Street, San Francisco, CA, 94132
view__c, Ocean;Golf Course;Panoramic
website_property_type__c, Single Family Home
window_features__c, Dual Pane Partial;Window Screens
pba__yearbuilt_pb__c, 1928
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530598190-1.jpg
