meta_query='key:subdist__c;value:Ingleside Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='382069' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70658
[post_author] => 4
[post_date] => 2018-11-30 20:30:32
[post_date_gmt] => 2018-11-30 20:30:32
[post_content] => Ingleside is a lot more down-to-earth than some of its swankier neighbors to the north, and it’s also a lot more affordable. Homes tend to be modest, some in the same family for generations. Unexpected views of downtown add to the attraction of this more-affordable neighborhood, which also has great public transit options and easy freeway access.
[post_title] => Ingleside Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => ingleside-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 11:51:10
[post_modified_gmt] => 2024-04-09 18:51:10
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70658
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_yoast_indexnow_last_ping, 1720868152
ffd_listing_title, 350 Head Street, San Francisco, CA, 94132
ffd_mls_id, 424030891
ffd_salesforce_id, a0EUd000002CTrWMAW
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 350 Head Street, San Francisco, CA, 94132
pba__address_pb__c, 350 Head Street, San Francisco, CA, 94132
agent_only_remarks__c, Offers welcome starting Tuesday, June 18, 2024.
architectural_style__c, Edwardian;Vintage
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 1909
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-06-03T17:47:20.000+0000
days_on_market__c, 40
dom__c, 17
ffd_description_pb, Transform your living experience with this stunning, move-in ready 4 BED, 4 BA, three-level luxury home nestled in the peaceful Ingleside Heights District of San Francisco. Recently renovated from the ground up, this single-family residence boasts a thoughtful and efficient floor plan. Top two floors encompasses a spacious 3 BED, 3 BA, while the ground level features a fully equipped 1 BED, 1 BA in-law apartment with its own private entrance, perfect for guests or rental. Experience elevated living with high ceilings and an abundance of natural light throughout. Conveniently located, it's 3 blocks from Oceanview Village businesses, HMart Shopping Plaza and Chase Bank. Also close to Stonestown's Trader Joe's, Citibank, Whole Foods, Target, and 85 Degrees Bakery. Enjoy easy access to outdoor activities with a half-block walk to Head Brotherhood Mini Park/Playground, Randolph Bright Mini Park/Playground, as well as a nearby dog park. Little Footprint Preschool (Mandarin Immersion) is 2 blocks away on Randolph Street. Transportation is a breeze with the Muni M line two blocks away providing direct access to downtown San Francisco. Quick access to Daly City BART station, SFO, and major freeways like 280 and 101 make commuting and travel simple.
district__c, SF District 3
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2024-07-13T10:48:15.000+0000
pba__latitude_pb__c, 37.7134181
pba__latitude_property__c, 37.7134181
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2024-05-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Kim
pba__listing_agent_lastname__c, Nguyen
listing_agent_mls_id__c, 800247
ffd_listingagentname, Kim D Nguyen
listing_agent_number__c, 800247
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, GCB
listing_office_name__c, Gold Coast Brokerage
listing_office_number__c, 28868
pba__listingprice_pb__c, 1288000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4641627
lower_level__c, Bedroom(s),Full Bath(s),Garage,Kitchen,Retreat,Street Entrance
mls_id__c, 424030891
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-06-03
original_price__c, 1288000
overall_days_on_market__c, -81968
parking_access__c, Independent
parking_features__c, Enclosed,Garage Door Opener
parking_type__c, Other;On Site (Single Family Only)
pba__pendingdate__c, 2024-06-20
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-07-12T21:42:50.000+0000
price_per_square_foot__c, 580.74
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000002CTrWMAW
sale_date__c, 2024-07-11
sale_price__c, 1568000
selling_agent_mls_id__c, EB1713759
selling_agent_number__c, 981398568
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Red Oak Realty
pba__status__c, Closed
pba__totalarea_pb__c, 2700
size__c, 2700
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Head
subdist__c, Ingleside Heights
ffd_name, 350 Head Street, San Francisco, CA, 94132
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1909
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530788448-1.jpg