meta_query='key:subdist__c;value:Ingleside Terraces|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='385909' 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, 1726106161
ffd_listing_title, 281 Urbano Drive, San Francisco, CA, 94127
ffd_mls_id, 424063450
ffd_salesforce_id, a0EUd0000033JkMMAU
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 281 Urbano Drive, San Francisco, CA, 94127
pba__address_pb__c, 281 Urbano Drive, San Francisco, CA, 94127
agent_only_remarks__c, Offers due Tuesday, Sept. 17th at 11:0am. Please use SFAR purchase contract. Pre-escrow opened with Joy Fogarty, First American Title, [email protected]; 415-645-8017; Escrow #3807-7155058. Disclosures available on Disclosures.IO or copy and paste this link in browser: https://app.disclosures.io/link/281-Urbano-Drive-1kguwcbs
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Double Oven;Built-In Refrigerator
architectural_style__c, Mediterranean
bath_features__c, Shower Stall(s);Jack & Jill
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1928
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-09-06T22:47:50.000+0000
days_on_market__c, 5
dom__c, 5
ffd_description_pb, Located in the historic Ingleside Terraces neighborhood, this architecturally stunning home represents quality craftsmanship & attention to detail. Formal entry w/welcoming staircase takes you to main level. Multiple arches, step-up living room w/beautiful parquet floors, cove ceiling, gas fireplace, attractive picture windows. Separate formal dining room features intricate wall/ceiling moldings. European-inspired eat-in kitchen w/commercial-style Viking range, Sub-Zero built-in refrigerator, custom stone & tile accents. Two bedrooms off hall overlook garden and share renovated full bath (option for en-suite). Primary bedroom has cedar-lined walk-in closet, custom shutters. Convenient half bath off hall completes main level. Spiral staircase down to bright, open lower level with 3rd bedroom and direct access to full bath. Laundry room, wet bar, home office w/built-in cabinets/bookcases & grand family/media room opens to south-facing deck w/numerous areas for entertaining. One car garage + parking in driveway. Immaculate multi-level backyard has several patio spaces. Close to MUNI Metro lines, major freeway access (via Junipero Serra or Ocean Avenue), local shops, cafes and restaurants, and Stonestown Galleria. Home is part of Ingleside Terraces Homeowners Association.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Carpet;Wood;Parquet
pba__hoafees__c, 40
pba__hoafrequency_pb__c, Annually
hoa_name__c, Ingleside Terraces Homeowners Assn
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Wet Bar
ffd_lastmodifieddate, 2024-09-12T01:47:21.000+0000
pba__latitude_pb__c, 37.7255277
pba__latitude_property__c, 37.7255277
laundry_features__c, Ground Floor;Washer Included;Dryer Included
listed_date__c, 2024-08-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Paul
pba__listing_agent_lastname__c, Barbagelata
listing_agent_mls_id__c, 342615
ffd_listingagentname, Paul Barbagelata
listing_agent_number__c, 342615
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, BARBCO
listing_office_name__c, BarbCo
listing_office_number__c, 28297
pba__listingprice_pb__c, 2295000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=2LzQUygkJDe&brand=0
pba__longitude_pb__c, -122.4686163
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage
mls_id__c, 424063450
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-09-06
open_house_end__c, 2024-09-12T18:30:00.000+0000
open_house_start__c, 2024-09-12T17:00:00.000+0000
original_price__c, 2295000
overall_days_on_market__c, -82063
parking_access__c, Independent
parking_features__c, Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 894.39
pba__propertytype__c, Single Family Residence
ListingId, a0EUd0000033JkMMAU
room_type__c, Kitchen;Living Room;Dining Room;Family Room;Media Room
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 2566
size__c, 2566
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Urbano
subdist__c, Ingleside Terraces
ffd_name, 281 Urbano Drive, San Francisco, CA, 94127
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1928
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530838151-1.jpg
