meta_query='key:subdist__c;value:Ingleside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='375684' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12158
[post_author] => 4
[post_date] => 2018-10-29 01:19:09
[post_date_gmt] => 2018-10-29 01:19:09
[post_content] => Ingleside is a lot more down-to-earth than some of its swankier neighbors on the north end of town, 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
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => ingleside
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 11:47:15
[post_modified_gmt] => 2024-04-09 18:47:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12158
[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, 1712796931
ffd_listing_title, 661 Lakeview Avenue, San Francisco, CA, 94112
ffd_mls_id, 424004642
ffd_salesforce_id, a0EUd000000vjOdMAI
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 0
address2__c, 661 Lakeview Avenue, San Francisco, CA, 94112
pba__address_pb__c, 661 Lakeview Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Contingent, No showing anymore. Pre escrow with Chicago title . Escrow officer Pauline Thach 415-405-1301, Escrow # FWPN 3542400003 Please email listing agent Ming Wu at " [email protected] " or text him at 415.279.6833 if you have any questions. For disclosure package please visit: https://app.disclosures.io/link/661-Lakeview-Avenue-svt67uxh
appliances__c, Dishwasher;Gas Water Heater;Disposal;Hood Over Range
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1921
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2024-03-09
ffd_createddate, 2024-01-25T02:46:48.000+0000
days_on_market__c, 77
dom__c, 65
ffd_description_pb, Welcome to your dream home nestled in a peaceful neighborhood. This renovated residence boasts 3 bedrooms, 2 baths. New upgraded electrical and plumbing work. Updated kitchen with stainless steel appliances. The open-concept design seamlessly connects the dining and living rooms, perfectly complementing the kitchen with its brand new cabinets. Additional highlights include a new LG dryer and washer, fresh interior and exterior paints, and luxurious waterproof oak flooring throughout. New furnace. Step outside to discover the spacious backyard, ideal for outdoor activities and gatherings. This versatile space serves as a perfect canvas for your imagination - whether you envision a serene retreat or an entertainer's paradise, the choice is yours! Furthermore, the new roofing, adds an extra layer of assurance. Rest easy, as all improvements were carried out under proper permits and meticulous design, ensuring the high standards of quality and safety. Don't miss the chance to turn this beautiful residence, located in the heart of the most sought-after neighborhood, into your dream home! Minutes drive from SFSU, CCSF, banks, restaurants, Whole Foods, Stonestown Galleria 101 and 280 freeways!
district__c, SF District 3
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Vinyl
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas;Fireplace(s)
ffd_lastmodifieddate, 2024-04-11T00:47:44.000+0000
pba__latitude_pb__c, 37.7181
pba__latitude_property__c, 37.7181
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2024-01-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Yue Ming
pba__listing_agent_lastname__c, Wu
listing_agent_mls_id__c, 813059
ffd_listingagentname, Ming Wu
listing_agent_number__c, 1059196
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, HPUS
listing_office_name__c, Remax Prestigious Properties
listing_office_number__c, 3224
pba__listingprice_pb__c, 1180000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.457868
lower_level__c, Garage
mls_id__c, 424004642
main_level__c, Bedroom(s);Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2024-01-24
original_price__c, 1180000
overall_days_on_market__c, -81837
pba__pendingdate__c, 2024-03-29
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-10T09:58:42.000+0000
price_per_square_foot__c, 1294.44
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000000vjOdMAI
roof__c, Shingle
room_type__c, Living Room;Dining Room
sale_date__c, 2024-04-08
sale_price__c, 1165000
selling_agent_mls_id__c, MLSL5098335
selling_agent_number__c, 981396591
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, KW Advisors
pba__status__c, Closed
pba__totalarea_pb__c, 900
size__c, 900
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Lakeview
subdist__c, Ingleside
ffd_name, 661 Lakeview Avenue, San Francisco, CA, 94112
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1921
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530723809-1.jpg