meta_query='key:subdist__c;value:Ingleside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='330293' 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-11-25 13:49:10
[post_modified_gmt] => 2024-11-25 21:49:10
[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
(
)
)
ffd_listing_title, 90 Geneva Avenue, San Francisco, CA, 94112
ffd_mls_id, 423727670
ffd_salesforce_id, a0E8W00000bFt51UAC
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 0
address2__c, 90 Geneva Avenue, San Francisco, CA, 94112
pba__address_pb__c, 90 Geneva Avenue, San Francisco, CA, 94112
agent_only_remarks__c, NO LOCKBOX until after 1st weekend open house. pre-sale escrow with Doma Title - Connie Choy. Offers due Tuesday, March 28th by 10am. Disclosures - https://app.disclosures.io/link/90-Geneva-Avenue-drftfde7
appliances__c, Microwave;Free Standing Gas Oven;Free Standing Refrigerator
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1948
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2023-03-17T10:48:54.000+0000
days_on_market__c, 655
dom__c, 12
ffd_description_pb, Cozy Ingelside home located steps from freeways w VIEWS, parks, Balboa BART, and the amenities of the trendy Ocean Ave and Mission St! This bright Mid-Century home features comfortable living room flooded with lots of natural sunlight & views of Twin Peak Mountains. Rich hardwood floors enhance common areas in the 3-bedroom home. The main level includes an eat-in kitchen, large bedrooms and bathroom. Downstairs, a large office/storage room and high ceilings in the spacious garage. Fenced paved backyard, where you can enjoy some downtime or bbq entertaining friends and family. All just minutes away from nearby BART, the 280, Whole Foods, Safeway, Target, and myriad restaurants on Ocean Ave, Mission St and the Stonestown Galleria. Walk to San Francisco City College! Perfect starter home in prime location, do not miss this opportunity!
district__c, SF District 3
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-07-13T18:34:33.000+0000
pba__latitude_pb__c, 37.722032
pba__latitude_property__c, 37.722032
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2023-03-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Samantha
pba__listing_agent_lastname__c, Huang
listing_agent_mls_id__c, 809630
ffd_listingagentname, Samantha J Huang
listing_agent_number__c, 1042187
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CIP01
listing_office_name__c, Corcoran Icon Properties
listing_office_number__c, 28939
pba__listingprice_pb__c, 849888
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=HroTf7bUb6B
pba__longitude_pb__c, -122.450462
lower_level__c, Garage
mls_id__c, 423727670
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-03-17
original_price__c, 849888
overall_days_on_market__c, -81524
parking_access__c, Tandem
parking_features__c, Attached,Garage Facing Front
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-03-29
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1057.58
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bFt51UAC
room_type__c, Kitchen;Living Room
sale_date__c, 2023-04-20
sale_price__c, 1047000
selling_agent_mls_id__c, 400593
selling_agent_number__c, 1019790
selling_co_agent_mls_id__c, 815651
selling_co_agent_number__c, 1073761
selling_co_office_mls_id__c, COMP7
selling_co_office_name__c, Compass
selling_co_office_number__c, 28751
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 990
size__c, 990
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Geneva
subdist__c, Ingleside
ffd_name, 90 Geneva Avenue, San Francisco, CA, 94112
view__c, Mountains
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1948
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530591623_f19ffe4e-da9b-44c3-ae2c-3be21fce25c2.jpg
_yoast_indexnow_last_ping, 1735679558