meta_query='key:subdist__c;value:Ingleside Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='321493' 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, 290 St Charles Avenue, San Francisco, CA, 94132
ffd_mls_id, 422710263
ffd_salesforce_id, a0E8W00000a4TyAUAU
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 290 St Charles Avenue, San Francisco, CA, 94132
pba__address_pb__c, 290 St Charles Avenue, San Francisco, CA, 94132
agent_only_remarks__c, Great opportunity to sell this lovely, well-located corner home! Disclosure link available upon request. Pre escrow has been opened with Mary Ann Bunnell, DOMA Title of California (formerly known as North American Title Company), 689 Portola Drive, San Francisco, CA 94127. Please reach out with any questions relative to title or escrow matters at [email protected]. Vacant with lockbox. You may go direct. Please leave a card. Please reach out to listing broker, Patrick Shannon, with any questions. Thanks!
appliances__c, Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Traditional;Art Deco
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1939
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-11-30T20:47:04.000+0000
days_on_market__c, 232
dom__c, 7
ffd_description_pb, Bright corner 2 bedroom, 1 1/4 bath home in ideal Ingleside Height's location. Upstairs features spacious living room, well-placed kitchen adjacent to formal dining room, 2 spacious bedrooms & full bathroom. Downstairs has two bonus/family rooms, laundry area, 1/4 bathroom, 1+ car garage (w/ expansion potential), and spacious rear yard. Home has double pane windows, lovely refinished hardwood floors, copper plumbing, newer water heater, and fresh paint inside and out. Conveniently located just one block from the Daly City BART station, and convenient to buses, shopping, Westlake Shopping Center, Stonestown, Lake Merced, numerous golf courses, and Brotherhood Way with easy freeway access to to downtown and the South Bay. Spacious 1,100 sq ft of living space. Quality built in 1939.
district__c, SF District 3
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced
pba__floortype_pb__c, Tile;Vinyl;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Natural Gas
ffd_lastmodifieddate, 2023-07-13T18:09:30.000+0000
pba__latitude_pb__c, 37.708818
pba__latitude_property__c, 37.708818
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2022-11-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Patrick
pba__listing_agent_lastname__c, Shannon
listing_agent_mls_id__c, 229293
ffd_listingagentname, Patrick H Shannon
listing_agent_number__c, 229293
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, TRIN
listing_office_name__c, Trinity Realty, Inc.
listing_office_number__c, 2129
pba__listingprice_pb__c, 988888
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.469407
lower_level__c, Garage,Partial Bath(s),Street Entrance
mls_id__c, 422710263
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-11-29
original_price__c, 988888
overall_days_on_market__c, -81416
parking_access__c, Independent
parking_features__c, Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-12-06
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 909.09
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000a4TyAUAU
road_surface_type__c, Paved
roof__c, Tar/Gravel
room_type__c, Storage;Kitchen;Living Room;Dining Room
sale_date__c, 2022-12-30
sale_price__c, 1000000
security_features__c, Security Gate;Double Strapped Water Heater;Window Security Bars
selling_agent_mls_id__c, 807001
selling_agent_number__c, 166018033
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Prime Metropolis Prop., Inc.
pba__status__c, Closed
pba__totalarea_pb__c, 1100
size__c, 1100
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, St Charles
subdist__c, Ingleside Heights
ffd_name, 290 St Charles Avenue, San Francisco, CA, 94132
website_property_type__c, Single Family Home
window_features__c, Dual Pane Partial;Window Screens
pba__yearbuilt_pb__c, 1939
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530558482-1.jpg