meta_query='key:subdist__c;value:Bayview Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='228404' 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, 1038 Ingerson Avenue, San Francisco, CA, 94124
ffd_mls_id, 487030
ffd_salesforce_id, a0E1I00000EHAF9UAP
address2__c, 1038 Ingerson Avenue, San Francisco, CA, 94124
pba__address_pb__c, 1038 Ingerson Avenue, San Francisco, CA, 94124
agent_only_remarks__c, Please contact LA for questions, disclosures, and offer instructions.
pba__fullbathrooms_pb__c, 5
pba__bedrooms_pb__c, 4
year_build_text__c, 1928
pba__city_pb__c, San Francisco
ffd_createddate, 2019-07-11T12:49:10.000+0000
days_on_market__c, 1469
dom__c, 21
ffd_description_pb, STUNNING modern view home nestled at the serene block of Bayview Heights. Behind the sleek, Marina facade, you will find a remarkably remodeled home with all of today's desired modern finishes. With 4 master en-suites & 2 half baths, generous living space & stylish finishes, you'll enjoy a perfect setting for relaxing & entertaining. The main floor features striking views of the city lights, hills and valleys, beautiful modern wide-plank hardwood floors & tons of natural lights flow throughout the home's open, airy layout. The chef's dream kitchen is clad with premium finishes & fixtures, including a massive central island, professional-grade appliances, & European style cabinetry. Walkout decks from both levels overlooking a spacious modern backyard garden. Two laundry areas & plenty of storage space to complete this just right home. It is well connected to public transit, just two blocks to MUNI T-line, with its close proximity to the Caltrain station, & quick access to 101/280.
district__c, SF District 10
external_listing__c, 1
hoa_dues__c, 0
ffd_lastmodifieddate, 2022-03-01T19:57:29.000+0000
pba__latitude_pb__c, 37.719667
pba__latitude_property__c, 37.719667
listed_date__c, 2019-07-08
pba__listing_agent_firstname__c, Juanjuan
pba__listing_agent_lastname__c, Huang
listing_agent_mls_id__c, 808889
listing_agent_number__c, 1038314
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP3
listing_office_name__c, Compass
listing_office_number__c, 27342
pba__listingprice_pb__c, 1095000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.393634
pba__lotsize_pb__c, 0.06
mls_id__c, 487030
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2019-07-11
original_price__c, 1288000
overall_days_on_market__c, 1469
parking__c, Attached,Garage,Auto Door,Interior Access
parking_access__c, Independent
parking_type__c, On Site
price_per_square_foot__c, 657.28
pba__propertytype__c, Single-Family Home
id, a0E1I00000EHAF9UAP
sale_date__c, 2019-08-30
sale_price__c, 1400000
selling_agent_mls_id__c, 808453
selling_agent_name__c, Kyle McCullough
selling_agent_number__c, 1035225
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, 2130
size__c, 2130
pba__state_pb__c, CA
pba__street_pb__c, Ingerson
subdist__c, Bayview Heights
ffd_name, 1038 Ingerson Avenue, San Francisco, CA, 94124
transportation__c, 2 Blocks
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1928
pba__postalcode_pb__c, 94124
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/353205-1.jpg
ListingId, a0E1I00000EHAF9UAP