meta_query='key:subdist__c;value:Ingleside Terraces|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215851' 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
(
)
)
ffd_listing_title, 27 Urbano Drive, San Francisco, CA, 94127
ffd_mls_id, 509215
ffd_salesforce_id, a0E1I00000TVBcIUAX
num_of_fireplaces__c, 0
num_of_rooms__c, 9
of_units__c, 0
address2__c, 27 Urbano Drive, San Francisco, CA, 94127
pba__address_pb__c, 27 Urbano Drive, San Francisco, CA, 94127
agent_only_remarks__c, Show by the appointment. Please call/text Fion or Sarah Prior to Showing. Showings subject to COVID-19 SIP guidelines. Provide signed PEAD form to agent. Pre-escrow opened with Editha Dionisio at Fidelity. Link to Disclosures: https://app.disclosures.io/link/27-Urbano-Drive-3umsppoc http://www.27urbanodr.com/ Seller needs at least 24-48 hours to response. Sold in As-Is condition. Lot Size differs from various sources & public records. MLS data pulled from public records. Buyers & Buyer's Agent to perform due diligence and verify square footage to their own satisfaction.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Compactor
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1914
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Sarah Wang
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-11-08T11:46:37.000+0000
days_on_market__c, 983
dom__c, 39
ffd_description_pb, Beautiful Victoria style single family home in Prestigious Ingleside Terraces neighborhood. Walking distance to Ocean Ave, restaurants, Whole Foods, Target. Desirable location. 1-mile walk to Balboa BART Station, Close to City College and SFSU. With shining hardwood floors throughout, the main floor boasts formal living and dining rooms, two bedrooms and two baths, and the eat in kitchen is a Chef's dream. Upstairs are two bedrooms with dual access to attic storage areas. Downstairs is a large laundry area which allows for the flexibility of office space or informal family room. There is a garage for two of more cars. Looking for huge storage space and built ADU? An incomparable amount in the basement accessed through the garage. A plan for basement is ready for a new owner. Don't miss this opportunity!
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway
electric__c, 220 Volts in Kitchen
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room
pba__floortype_pb__c, Vinyl;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:39:15.000+0000
pba__latitude_pb__c, 37.72469
pba__latitude_property__c, 37.72469
laundry_features__c, Washer/Dryer Included
listed_date__c, 2020-10-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Hoi Yin Fion
pba__listing_agent_lastname__c, Yau
listing_agent_mls_id__c, 813803
ffd_listingagentname, Fion Yau
listing_agent_number__c, 1063040
listing_co_agent_mls_id__c, MLSL5079688
listing_co_agent_number__c, 981344928
listing_co_office_mls_id__c, APR-4
listing_co_office_name__c, Compass
listing_co_office_number__c, 981048570
listing_office_mls_id__c, COLD02
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 874
pba__listingprice_pb__c, 1870000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/478152330
pba__longitude_pb__c, -122.46353
pba__lotsize_pb__c, 0.26
mls_id__c, 509215
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-11-08
original_price__c, 1870000
overall_days_on_market__c, 112
parking__c, Detached,Attached
parking_features__c, Attached,Detached
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Patio(s)
pba__pendingdate__c, 2021-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1017.98
pba__propertytype__c, Single Family Residence
id, a0E1I00000TVBcIUAX
roof__c, Composition
room_type__c, Office;Laundry
sale_date__c, 2021-01-20
sale_price__c, 2152000
selling_agent_mls_id__c, 803981
selling_agent_number__c, 166013368
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Flannery Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 2114
size__c, 2114
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Urbano
subdist__c, Ingleside Terraces
ffd_name, 27 Urbano Drive, San Francisco, CA, 94127
transportation__c, 1 Block
view__c, San Francisco
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1914
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/373137-1.jpg
ListingId, a0E1I00000TVBcIUAX