meta_query='key:subdist__c;value:Ingleside Terraces|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='376606' 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, 1714129092
ffd_listing_title, 450 Urbano Drive, San Francisco, CA, 94127
ffd_mls_id, 424017509
ffd_salesforce_id, a0EUd000001aGAXMA2
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 450 Urbano Drive, San Francisco, CA, 94127
pba__address_pb__c, 450 Urbano Drive, San Francisco, CA, 94127
agent_only_remarks__c, OFFER DATE: Thurs, 4/4 by 11am. Tax Records shows 1220 sqft, 2 bed/1ba & Graphic Artist shows 1384 sqft of living space - Buyers to investigate to their satisfaction. Schedule an appointment through ShowingTime and access instructions will be sent to you. Garage door opener is in the kitchen drawer to the left of th sink - please return after using it. One or more of the ultimate owners of the seller is a licensed real estate professional in California. No buyer letters please per sellers request. Association site: www.ithasf.org Disclosure package link: https://app.disclosures.io/link/450-Urbano-Drive-h5ppkvxs
appliances__c, Dishwasher;Microwave;Disposal;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Spanish
bath_features__c, Shower Stall(s);Tub;Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1925
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Peter H Fong
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-03-28T00:47:40.000+0000
days_on_market__c, 30
dom__c, 8
ffd_description_pb, Step into the timeless elegance of Ingleside Terrace, a meticulously crafted residence park conceived in 1910 by renowned architect Joseph Leonard. Fast forward to 2024, where we proudly present 450 Urbano Drive, a captivating Spanish-style abode that seamlessly marries the opulent craftsmanship of the 1920s with the contemporary comforts craved by today's homeowner. Original hardwood floors, cherry inlay detailing, and craftsman windows adorn the sunlit interior. The new chef's kitchen boasts textured backsplash tiles, stone countertops, and modern cabinetry. Outside, a spacious deck overlooks a vast yard, perfect for gardening or relaxation. With two spacious bedrooms, two remodeled bathrooms, an office/den, and ample storage, this home offers versatility and comfort. Complete with a garage wired for possible EV charging and a generous driveway, 450 Urbano Drive is a harmonious blend of classic charm and modern luxury. Conveniently located in close proximity to Stonestown Shopping Center, Aptos Park, Junipero Serra Playground, CAIS school, SFSU, Lowell, Muni Transit/Tech Shuttle Stops on 19th Ave, and Ocean Ave Commercial offerings, this residence promises both tranquility and accessibility - a must-see for those seeking timeless elegance paired with urban convenience.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Organized Activities
pba__hoafees__c, 40
pba__hoafrequency_pb__c, Annually
hoa_name__c, Ingleside Terraces Homes Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Fireplace(s)
ffd_lastmodifieddate, 2024-04-26T10:47:13.000+0000
pba__latitude_pb__c, 37.7237075
pba__latitude_property__c, 37.7237075
laundry_features__c, In Kitchen;Hookups Only;Inside Area
listed_date__c, 2024-03-21
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Timothy
pba__listing_agent_lastname__c, Fong
listing_agent_mls_id__c, 400313
ffd_listingagentname, Timothy G Fong
listing_agent_number__c, 400313
listing_co_agent_mls_id__c, 039902
listing_co_agent_number__c, 39902
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1299900
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.469739
mls_id__c, 424017509
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 4
on_market_date__c, 2024-03-27
original_price__c, 1299900
overall_days_on_market__c, -81900
parking_access__c, Tandem
parking_features__c, Detached,Enclosed,Garage Door Opener,Uncovered Parking Spaces 2+
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2024-04-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-25T13:54:47.000+0000
price_per_square_foot__c, 1219.51
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001aGAXMA2
sale_date__c, 2024-04-25
sale_price__c, 1700000
selling_agent_mls_id__c, 814206
selling_agent_number__c, 1064966
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, eXp Realty of California, Inc
pba__status__c, Closed
pba__totalarea_pb__c, 1394
size__c, 1394
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Urbano
subdist__c, Ingleside Terraces
ffd_name, 450 Urbano Drive, San Francisco, CA, 94127
website_property_type__c, Single Family Home
window_features__c, Bay Window(s);Dual Pane Partial
pba__yearbuilt_pb__c, 1925
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530748965-1.jpg