meta_query='key:subdist__c;value:Ingleside Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217894' 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, 157 St Charles Avenue, San Francisco, CA, 94132
ffd_mls_id, 421532292
ffd_salesforce_id, a0E1I00000TxJBkUAN
num_of_fireplaces__c, 1
num_of_rooms__c, 10
of_units__c, 0
address2__c, 157 St Charles Avenue, San Francisco, CA, 94132
pba__address_pb__c, 157 St Charles Avenue, San Francisco, CA, 94132
agent_only_remarks__c, All renovation work done with permits. schedule showing appointment via Showing time. Please send PEAD to [email protected] Property will not be cleaned and disinfected before any persons are allowed to enter or after any such persons leave the Property, as stated in Paragraph 4(ii) of form PEAD-S. Any Persons, or Agents, upon entering the Property, agree to assume all associated risk and indemnify, release, and hold harmless any liability from Seller/s or Listing Agent. Offer day April 6 by 5pm. Seller reserve the right to consider serious and strong preemptive offer. disclosure link: https://app.disclosures.io/link/157-Saint-Charles-Avenue-jsncsl1g
appliances__c, Dishwasher;Gas Water Heater;Microwave;Disposal;Tankless Water Heater;Free Standing Gas Oven;Free Standing Gas Range;ENERGY STAR Qualified Appliances;Free Standing Refrigerator
architectural_style__c, Contemporary
bath_features__c, Tile
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 1937
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2021-03-27T03:07:31.000+0000
days_on_market__c, 845
dom__c, 12
ffd_description_pb, A graciously fully renovated to the studs 4 bed 4 bath home with a large sunny garden. this is the perfect sanctuary for working, living and entertaining in modern elegance. Boasting numerous upgrades throughout, contemporary style home features a custom open airy design and premium finishes. The gourmet kitchen with Bosch black stainless appliances. Top floor (1025sf) offers open floor plan with open kitchen to dining and living room, two bedrooms side by side in the back, two full baths (including master suite). Lower floor (975sf + 207sf garage) is built out with additional two bedrooms, two full baths En suites, family room, laundry room and one car garage. All 4 bedrooms have their individual access to the back yard. It's conveniently located just few blocks to Daly city Bart station, Muni bus stops. Easy access to Hyw 280, and short distance shopping at Ocean view plaza. 220v electric vehicle charging outlet in garage
district__c, SF District 3
driveway_sidewalks__c, Unpaved
electric__c, 220 Volts
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard;Wood
fireplace_features__c, Living Room
pba__floortype_pb__c, Simulated Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas;Fireplace(s)
interior_features__c, Skylight Tube;Skylight(s)
ffd_lastmodifieddate, 2022-01-25T15:48:13.000+0000
pba__latitude_pb__c, 37.711252
pba__latitude_property__c, 37.711252
laundry_features__c, Laundry Closet;Gas Hook-Up
listed_date__c, 2021-03-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Yingsha
pba__listing_agent_lastname__c, Miao
listing_agent_mls_id__c, 807260
ffd_listingagentname, Vanessa Miao
listing_agent_number__c, 1013043
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CAFH
listing_office_name__c, Century 21 Realty Alliance Fine Homes and Estates
listing_office_number__c, 166014509
pba__listingprice_pb__c, 1499000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=https://my.matterport.com/show/?m=Hr52L219oFd&brand=0
pba__longitude_pb__c, -122.469036
mls_id__c, 421532292
main_level__c, Master Bedroom;Bedroom(s);Garage;Family Room;Street Entrance
master_bathroom_features__c, Tub w/Shower Over;Tile;Closet
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-03-26
original_price__c, 1499000
overall_days_on_market__c, 127
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Covered Deck
pba__pendingdate__c, 2021-04-07
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 844.44
pba__propertytype__c, Single Family Residence
id, a0E1I00000TxJBkUAN
roof__c, Tar/Gravel;Flat
room_type__c, Laundry;Kitchen;Master Bedrooms 2+;Living Room;Master Bathroom;Family Room;Master Bedroom
sale_date__c, 2021-05-21
sale_price__c, 1688888
security_features__c, Carbon Mon Detector
selling_agent_mls_id__c, 810145
selling_agent_number__c, 1044931
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Surpass Real Estate & Finance
pba__status__c, Closed
pba__totalarea_pb__c, 2000
size__c, 2000
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, St Charles
subdist__c, Ingleside Heights
ffd_name, 157 St Charles Avenue, San Francisco, CA, 94132
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Weather Stripped
pba__yearbuilt_pb__c, 1937
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530206787-1.jpg
ListingId, a0E1I00000TxJBkUAN