meta_query='key:subdist__c;value:Ingleside Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='221986' 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, 234 Arch Street, San Francisco, CA, 94132
ffd_mls_id, 421611894
ffd_salesforce_id, a0E8W00000V1mmvUAB
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 234 Arch Street, San Francisco, CA, 94132
pba__address_pb__c, 234 Arch Street, San Francisco, CA, 94132
agent_only_remarks__c, Go and Show. Home is vacant and staged. Disclosure link available - email agents. Seller is an investor and has never lived in property. One or more members of the selling entity holds a CA real estate license. Offer date Tuesday 11/23 by 2pm. Seller has a right to accept or reject a preemptive offer. Text Helen 650-271-2308 with any questions. Buyer/Agent to verify all info. Thanks for showing!
appliances__c, Dishwasher;Microwave;Disposal;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Contemporary
bath_features__c, Shower Stall(s);Tile;Stone
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1940
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Maxine M Stover
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2021-11-13T19:46:57.000+0000
days_on_market__c, 613
dom__c, 11
ffd_description_pb, Welcome home to 234 Arch Street located in the highly sought after Ingleside neighborhood close to SFSU, City College, Stonestown Galleria Mall, Ocean Beach,restaurants and much more! This stunning property has been fully reimagined throughout highlighting modern upgrades while maintaining it's classic city charm! Your gated entry with ample built-ins invite you into the gorgeous light and bright living spaces. Downstairs you'll find a permitted bedroom with a full bath making it a great addition to greet extended family and friends. Upstairs you'll find 2 bedrooms and an impressive jaw dropping bath. The sparkling, updated eat-in kitchen features - SS appliances, white shaker cabinets, Quartz countertops and designer ombre backsplash will make entertaining and meals by the fireplace a must! The private backyard with drought resistant landscaping is ready for your added touches to truly make this a retreat that you'll be delighted to call home!
district__c, SF District 3
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Fireplace(s)
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2022-01-25T16:06:15.000+0000
pba__latitude_pb__c, 37.7149359
pba__latitude_property__c, 37.7149359
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2021-11-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Helen
pba__listing_agent_lastname__c, Yong
listing_agent_mls_id__c, 981607
ffd_listingagentname, Helen Yong
listing_agent_number__c, 981607
listing_co_agent_mls_id__c, E400091
listing_co_agent_number__c, 981098724
listing_co_office_mls_id__c, 7D1925
listing_co_office_name__c, eXp Realty of California, Inc
listing_co_office_number__c, 981083927
listing_office_mls_id__c, EXPRE
listing_office_name__c, eXp Realty of California, Inc
listing_office_number__c, 26334
pba__listingprice_pb__c, 1195000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4669325
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage,Street Entrance
mls_id__c, 421611894
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, 2021-11-13
original_price__c, 1195000
overall_days_on_market__c, 60
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-11-24
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1028.99
pba__propertytype__c, Single Family Residence
id, a0E8W00000V1mmvUAB
roof__c, Bitumen
sale_date__c, 2021-12-17
sale_price__c, 1420000
selling_agent_mls_id__c, 666666
selling_agent_number__c, 666666
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1380
size__c, 1380
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Arch
subdist__c, Ingleside Heights
ffd_name, 234 Arch Street, San Francisco, CA, 94132
view__c, City Lights;Hills
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1940
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530359874-1.jpg
ListingId, a0E8W00000V1mmvUAB