meta_query='key:subdist__c;value:Ingleside Terraces|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='216030' 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, 104 Lunado Way, San Francisco, CA, 94127
ffd_mls_id, 509875
ffd_salesforce_id, a0E1I00000TjLCbUAN
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 104 Lunado Way, San Francisco, CA, 94127
pba__address_pb__c, 104 Lunado Way, San Francisco, CA, 94127
agent_only_remarks__c, Please use showing time app to schedule. Agents must send PEAD prior to entry, Disclosures IO link in connected here to MLS. OFFER date TBD. tax records say 1885 sq. feet but we are going to have it measured. may not include extension of master bath or atrium. Please use SFAR forms when offers are put together.
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator;Hood Over Range;ENERGY STAR Qualified Appliances;Freezer
architectural_style__c, Traditional;Spanish/Med
bath_features__c, Tub w/Shower Over;Shower Stall(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1925
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Anna L Barbagelata
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-11-17T23:46:12.000+0000
days_on_market__c, 974
dom__c, 10
ffd_description_pb, Classic Mediterranean Home in the historic Ingleside Terraces neighborhood. All on one level are the formal living and dining rooms, grand in size, and 3 large bedrooms plus an atrium office space looking out to, and with direct access to, the expansive rear yard with gazebo and fountain. The master suite has a proper full-sized dressing room and closet, full double sink vanity and large walk in shower. Formal front rooms have period details intact, trim and doors plus lovingly restored kitchen showcasing abundant craftsman cabinets and counter space. All new stainless appliances including a gas range in kitchen are adjacent to a charming sunny breakfast room. Huge garage with parking for two tandem plus storage areas. This home is conveniently located near Stonestown Galleria featuring Trader Joes and soon to come Whole Foods, plus easy access to 280/101 freeways and only about 15 minutes to SFO. Close to both SF State University, Lowell High School and Aptos Middle Schools.
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Carpet;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
hoa_name__c, Ingleside Terraces Homes Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:40:04.000+0000
pba__latitude_pb__c, 37.723975
pba__latitude_property__c, 37.723975
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2020-11-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Sandra
pba__listing_agent_lastname__c, Gandolfo
listing_agent_mls_id__c, 803790
ffd_listingagentname, Sandy Gandolfo
listing_agent_number__c, 803790
listing_co_agent_mls_id__c, 223465
listing_co_agent_number__c, 223465
listing_co_office_mls_id__c, BARBCO
listing_co_office_name__c, BarbCo
listing_co_office_number__c, 28297
listing_office_mls_id__c, BARBCO
listing_office_name__c, BarbCo
listing_office_number__c, 28297
pba__listingprice_pb__c, 1998000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.104Lunado.com
pba__longitude_pb__c, -122.470922
pba__lotsize_pb__c, 0.17
mls_id__c, 509875
main_level__c, Full Bath(s);Master Bedroom;Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-11-17
original_price__c, 1998000
overall_days_on_market__c, 44
parking__c, Garage,Interior Access
parking_features__c, Interior Access,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-11-27
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
id, a0E1I00000TjLCbUAN
room_type__c, Office;Atrium
sale_date__c, 2020-12-18
sale_price__c, 1975000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 806718
selling_agent_name__c, Sherri Howe
selling_agent_number__c, 166017501
selling_co_agent_mls_id__c, 814525
selling_co_agent_name__c, Savinie Lam
selling_co_agent_number__c, 1066691
selling_co_office_mls_id__c, CGL01
selling_co_office_name__c, Corcoran Global Living
selling_co_office_number__c, 28273
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Lunado
subdist__c, Ingleside Terraces
ffd_name, 104 Lunado Way, San Francisco, CA, 94127
transportation__c, 3 Blocks
website_property_type__c, Single Family Home
window_features__c, Dual Pane;Window Screens
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/373905-1.jpg
ListingId, a0E1I00000TjLCbUAN
