meta_query='key:subdist__c;value:Ingleside Terraces|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='384524' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12176
[post_author] => 4
[post_date] => 2018-10-30 00:43:33
[post_date_gmt] => 2018-10-30 00:43:33
[post_content] => Towering pillars denote neighborhood entrances to this classic residential park. Suburban, ex-urban, ahead of its time or perfectly timed? Wide streets, large lots, and fully detached homes gently grace what was once the hottest horse race in town.
[post_title] => Ingleside Terraces
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => ingleside-terraces
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-11 08:28:59
[post_modified_gmt] => 2024-04-11 15:28:59
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12176
[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, 1724205476
ffd_listing_title, 9 De Soto Street, San Francisco, CA, 94127
ffd_mls_id, 424047707
ffd_salesforce_id, a0EUd000002XazfMAC
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 9 De Soto Street, San Francisco, CA, 94127
pba__address_pb__c, 9 De Soto Street, San Francisco, CA, 94127
agent_only_remarks__c, Buyers are recommended to do their own measurements as far as square footage and ceiling heights. The square footage and ceiling heights quoted in the marketing materials are approximate measurements and may vary depending on who is doing the measurements. We also recommend a buyer try their cars in the garage. The shelving may need to be removed in order to accommodate two cars. Easy to show at any time. Call, text or email Robert at 415-748-1481 or [email protected] or Barbara at 415-806-7906 or [email protected] for appointment.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Built-In Gas Oven;Wine Refrigerator;Built-In Refrigerator;Built-In Freezer
bath_features__c, Tub w/Shower Over;Shower Stall(s)
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 5
year_build_text__c, 1923
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Barbara J Callan
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-07-10T19:46:52.000+0000
days_on_market__c, 41
dom__c, 18
ffd_description_pb, On a beautiful prime block in one of San Franciscos most desirable neighborhoods, Ingleside Terraces, sits this exceptional state-of-the-art grand scale view home that showcases over approx. 3800 sqft of amazing living space, with ceiling heights going as high as 12' 11'' and higher in the dramatic staircase with skylight! The volume is extraordinary. It offers customized architectural detail throughout including bold moldings, shimmering hardwood floors, double-pane windows, cathedral ceilings & stunning fireplace. The amazing renovation was created to provide the perfect floor plan & flow for today's modern living, including an open kitchen & breakfast area, an elegant living room, dining room, media room, guest quarters, home office & so much more! The amazing flat, beautifully landscaped walk-out backyard with access from the kitchen & breakfast area creates a park-like setting & the ideal environment. Close to great schools, shops, restaurants, & transportation.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 0
pba__hoafrequency_pb__c, Annually
hoa_name__c, Ingleside Terraces Homes Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
interior_features__c, Skylight(s);Storage Area(s);Cathedral Ceiling
ffd_lastmodifieddate, 2024-08-21T01:47:39.000+0000
pba__latitude_pb__c, 37.7219779
pba__latitude_property__c, 37.7219779
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2024-05-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Robert
pba__listing_agent_lastname__c, Callan
listing_agent_mls_id__c, 804668
ffd_listingagentname, Robert R Callan Jr.
listing_agent_number__c, 166014312
listing_co_agent_mls_id__c, 215760
listing_co_agent_number__c, 215760
listing_co_office_mls_id__c, STHB4
listing_co_office_name__c, Sotheby's International Realty
listing_co_office_number__c, 28397
listing_office_mls_id__c, STHB4
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 28397
pba__listingprice_pb__c, 3200000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=qLExdvujCNv&brand=0
pba__longitude_pb__c, -122.4668088
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 424047707
main_level__c, Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Tub;Double Sinks;Multiple Shower Heads;Skylight/Solar Tube
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-07-10
original_price__c, 3200000
overall_days_on_market__c, -82005
parking_access__c, Tandem
parking_features__c, Detached,Tandem Garage,Uncovered Parking Spaces 2+
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Front Porch
pba__pendingdate__c, 2024-07-28
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-08-20T12:39:52.000+0000
price_per_square_foot__c, 859.38
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000002XazfMAC
room_type__c, Office;Kitchen;Living Room;Dining Room;Media Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2024-08-19
sale_price__c, 3300000
selling_agent_mls_id__c, 806092
selling_agent_number__c, 166016263
selling_co_agent_mls_id__c, 809156
selling_co_agent_number__c, 1040848
selling_co_office_mls_id__c, VANG02
selling_co_office_name__c, Vanguard Properties
selling_co_office_number__c, 166013449
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 3840
size__c, 3840
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, De Soto
subdist__c, Ingleside Terraces
ffd_name, 9 De Soto Street, San Francisco, CA, 94127
view__c, Ocean;Sutro Tower
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1923
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530807366-1.jpg