meta_query='key:subdist__c;value:Merced Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='332303' 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, 474 Vernon Street, San Francisco, CA, 94132
ffd_mls_id, 423730088
ffd_salesforce_id, a0E8W00000bbaOiUAI
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 474 Vernon Street, San Francisco, CA, 94132
pba__address_pb__c, 474 Vernon Street, San Francisco, CA, 94132
appliances__c, Dishwasher;Gas Water Heater;Free Standing Gas Range
architectural_style__c, Traditional
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1945
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Sharon S Bacigalupi
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-04-22T00:48:53.000+0000
days_on_market__c, 36
dom__c, 11
ffd_description_pb, Welcome to this lovely updated Marina Style home located on a sought after flat block in the coveted Merced Heights neighborhood. This rare offering is just doors away from the prestigious Ingleside Terraces. The main level offers a comfortable floor plan featuring a sun-drenched living room with beautiful corner wood-burning fireplace, formal dining room showcasing a huge skylight, an updated eat-in kitchen boasting new counter-tops, sink, fixtures and stainless appliances plus a full bathroom with a seperate tub and stall shower plus two generous sized bedrooms that overlook the large backyard. Interior access leads you to the lower level that includes a flexible bonus media/family room or 3rd bedroom that opens onto a verdant garden with patio. The lower level is completed by a generous garage with possible room for additional expansion. This home is ready to move in with gorgeous refinished hardwood floors,freshly painted interior and exterior and new fixtures through out. Located within walking distance to Stonestown (Whole Foods, Trader Joes, Boutique shops and restaurants), 280 access and excellent schools and transportation.
district__c, SF District 3
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Linoleum;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry;Skylight(s)
ffd_lastmodifieddate, 2023-05-27T01:48:28.000+0000
pba__latitude_pb__c, 37.7210165
pba__latitude_property__c, 37.7210165
laundry_features__c, Washer Included
listed_date__c, 2023-02-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Marianne
pba__listing_agent_lastname__c, Bacigalupi Schier
listing_agent_mls_id__c, 971052
ffd_listingagentname, Marianne Bacigalupi Schier
listing_agent_number__c, 971052
listing_co_agent_mls_id__c, 369072
listing_co_agent_number__c, 369072
listing_co_office_mls_id__c, COMP12
listing_co_office_name__c, Compass
listing_co_office_number__c, 28739
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 1099000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=euin4VTGDoS&mls=1" frameborder="0" allowfullscreen allow="vr">
pba__longitude_pb__c, -122.4678606
lower_level__c, Family Room
mls_id__c, 423730088
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-04-21
original_price__c, 1099000
overall_days_on_market__c, -81559
parking_access__c, Independent
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-05-02
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-05-26T12:39:35.000+0000
price_per_square_foot__c, 1046.81
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bbaOiUAI
room_type__c, Kitchen;Living Room;Dining Room;Family Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2023-05-26
sale_price__c, 1230000
selling_agent_mls_id__c, 812893
selling_agent_number__c, 1058626
selling_co_agent_mls_id__c, MLSL5085934
selling_co_agent_number__c, 981360357
selling_co_office_mls_id__c, KINE-1
selling_co_office_name__c, Kinetic Real Estate
selling_co_office_number__c, 981083883
selling_office_name__c, Kinetic Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1175
size__c, 1175
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Vernon
subdist__c, Merced Heights
ffd_name, 474 Vernon Street, San Francisco, CA, 94132
view__c, Garden/Greenbelt
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1945
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530607629-1.jpg