meta_query='key:subdist__c;value:Ingleside Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='236851' 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
(
)
)
ffd_listing_title, 546 Head Street, San Francisco, CA, 94132
ffd_mls_id, 422666794
ffd_salesforce_id, a0E8W00000XiOUSUA3
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 546 Head Street, San Francisco, CA, 94132
pba__address_pb__c, 546 Head Street, San Francisco, CA, 94132
agent_only_remarks__c, Please refer to the offer instructions on dislosures.io. Front door needs a push to open. Please lock up, leave downstairs lights on and watch your steps and head! No death on the property. Not a probate or trust sale. Sold as is. Pls include Addendum. SFAR Purchase Agreement required. Will require cash purchase. Perfect as a flip or for an end-user. Seller's personal property in the garage is excluded from the sale. Pre escrow has been opened with Mary Ann Bunnell, DOMA Title of CA (formerly known as North American Title Company), 689 Portola Drive, San Francisco, CA 94127, [email protected].
architectural_style__c, Traditional
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1938
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2022-06-13T18:46:50.000+0000
days_on_market__c, 401
dom__c, 10
ffd_description_pb, Calling all contractors and developers! Mega fixer opportunity in prime Ingleside location between Sargent & Shield Streets. First sale since home was built in 1938. Tremendous redevelopment potential or for an end user. Large lot and great floorplan and views from the bedrooms. Currently vacant 2 Bed, 1 Bath, 1 car garage with lots of space in the back. Main level has a formal living room with large windows, fireplace and vaulted ceiling, formal dining room with attached sunroom, spacious kitchen, 2 backyard-facing bedrooms and one bathroom. One of the bedrooms has an access to a deck. Full garage with expansion potential and exit to backyard. Wonderful location, very walkable with excellent transit, per walkscore site. Close to Ocean Ave, W. Portal & Stonestown shopping/dining, markets (Whole Foods), parks, schools & EZ commute options including BART, MUNI & freeways!
district__c, SF District 3
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Fenced
fireplace_features__c, Living Room
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-07-02T22:47:18.000+0000
pba__latitude_pb__c, 37.7170012
pba__latitude_property__c, 37.7170012
listed_date__c, 2022-06-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Yelena
pba__listing_agent_lastname__c, Laudati
listing_agent_mls_id__c, 809117
ffd_listingagentname, Yelena Laudati
listing_agent_number__c, 1040477
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 750000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4642373
lower_level__c, Garage,Street Entrance
mls_id__c, 422666794
main_level__c, Full Bath(s);Bedroom(s);Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-06-13
original_price__c, 750000
overall_days_on_market__c, -81247
parking_access__c, Independent
parking_features__c, Attached,Covered,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-06-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-07-02T09:21:59.000+0000
price_per_square_foot__c, 833.04
pba__propertytype__c, Single Family Residence
id, a0E8W00000XiOUSUA3
room_type__c, Storage;Bonus Room;Sun Room;Kitchen;Living Room;Dining Room
sale_date__c, 2022-07-01
sale_price__c, 958000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 802485
selling_agent_number__c, 802485
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Pellego, Inc.
pba__status__c, Closed
pba__totalarea_pb__c, 1150
size__c, 1150
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Head
subdist__c, Ingleside Heights
ffd_name, 546 Head Street, San Francisco, CA, 94132
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1938
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530477147-1.jpg
ListingId, a0E8W00000XiOUSUA3