meta_query='key:subdist__c;value:Bayview Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214851' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70678
[post_author] => 4
[post_date] => 2018-11-30 20:31:14
[post_date_gmt] => 2018-11-30 20:31:14
[post_content] => You probably didn't know this neighborhood was a thing -- it's a tiny triangle of land bounded by the 101 to the west, Bayview Park to the east, and the industrial land of the Bayview to the north. It's similar in style to the Bayview, except none of the streets make any sense!
[post_title] => Bayview Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => bayview-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 10:01:08
[post_modified_gmt] => 2024-04-09 17:01:08
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70678
[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, 1063 Ingerson Avenue, San Francisco, CA, 94124
ffd_mls_id, 506427
ffd_salesforce_id, a0E1I00000THl6sUAD
num_of_fireplaces__c, 0
num_of_rooms__c, 9
of_units__c, 0
address2__c, 1063 Ingerson Avenue, San Francisco, CA, 94124
pba__address_pb__c, 1063 Ingerson Avenue, San Francisco, CA, 94124
agent_only_remarks__c, Please visit www.1063ingerson.com for virtual 3D video tour & additional info. Showing subject to PEAD & COVID-19 Showing guidelines. Buyers to provide approval letter and/or proof of funds if cash prior to entry. Email for disclosures. Include signature page w/ offer. Offers due 9/29 at 12 p.m. Seller may consider a strong preemptive offer. Pre-Escrow opened w/ Bethe Battalio at Fidelity National Title Co, Escrow #FSFM-0062002729. Contact Richard at 415.680.5042 w/ any questions. Thanks for showing!
appliances__c, Gas Water Heater;Gas Range;Refrigerator;Hood Over Range
architectural_style__c, Traditional
bath_features__c, Shower Stall(s);Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 6
year_build_text__c, 1914
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-09-20
ffd_createddate, 2020-09-18T19:45:28.000+0000
days_on_market__c, 1034
dom__c, 14
ffd_description_pb, After 50+ years in the same family, this spacious single-family home is ready for some TLC and its new owner's vision! Located in the desirable Bayview Heights neighborhood, the owners expanded the home in 2000 to include a master ensuite that increased the floorplan to 6 bedrooms with 2.5 baths. There are partial hill views from the two living rooms and one bedroom. The spacious eat-in kitchen leads to a larger rear yard with plenty of space for development and any entertainer's delight, with wine grapes ripe for the picking. Conveniently located to Bayview Park, Candlestick Point State Recreation Area and commuter access to Light Rail, public transit, Hwy 101 & 280. A must see before it is gone!
district__c, SF District 10
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
pba__floortype_pb__c, Carpet;Linoleum;Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:34:56.000+0000
pba__latitude_pb__c, 37.7195924
pba__latitude_property__c, 37.7195924
laundry_features__c, In Garage;Washer/Dryer Included;Hookups Only
listed_date__c, 2020-08-21
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Richard
pba__listing_agent_lastname__c, Sarro
listing_agent_mls_id__c, 807008
ffd_listingagentname, Richard G Sarro
listing_agent_number__c, 846514918
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CGL06
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28275
pba__listingprice_pb__c, 798000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.3942883
pba__lotsize_pb__c, 0.11
lower_level__c, Family Room,Partial Bath(s)
mls_id__c, 506427
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-09-18
original_price__c, 798000
overall_days_on_market__c, 125
parking__c, Attached,Garage,Interior Access
parking_access__c, Tandem
parking_features__c, Attached,Interior Access,Tandem Garage,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Patio(s);Covered Patio
pba__pendingdate__c, 2020-10-02
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 555.56
pba__propertytype__c, Single Family Residence
id, a0E1I00000THl6sUAD
roof__c, Composition;Shingle
room_type__c, Storage
sale_date__c, 2020-10-22
sale_price__c, 975000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 804560
selling_agent_name__c, Tanya S. Dzhibrailova
selling_agent_number__c, 183503881
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 1755
size__c, 1755
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Ingerson
subdist__c, Bayview Heights
ffd_name, 1063 Ingerson Avenue, San Francisco, CA, 94124
transportation__c, 3 Blocks
view__c, Partial;Hills
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1914
pba__postalcode_pb__c, 94124
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/370564-1.jpg
ListingId, a0E1I00000THl6sUAD