meta_query='key:subdist__c;value:Lone Mountain|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219311' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70653
[post_author] => 4
[post_date] => 2018-11-30 20:30:26
[post_date_gmt] => 2018-11-30 20:30:26
[post_content] => Charming single-family homes on streets that made sense before the University of San Francisco left its footprint on the neighborhood. The most charming circular street you'll ever meet (hello, Ewing Terrace). Discontiguous streets and student life just north of the North Panhandle.
[post_title] => Lone Mountain
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => lone-mountain
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-17 07:57:25
[post_modified_gmt] => 2024-04-17 14:57:25
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70653
[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, 42 Rossi Avenue, San Francisco, CA, 94118
ffd_mls_id, 421559619
ffd_salesforce_id, a0E1I00000UTx8iUAD
num_of_fireplaces__c, 1
num_of_rooms__c, 9
of_units__c, 0
address2__c, 42 Rossi Avenue, San Francisco, CA, 94118
pba__address_pb__c, 42 Rossi Avenue, San Francisco, CA, 94118
agent_only_remarks__c, Offers, if any, due by noon on Wednesday June 16th. For disclosures choose the following link: https://app.disclosures.io/link/42-Rossi-Avenue-dujm9wbq COVID compliant showings only, please review all online media contained in this listing prior to scheduling an appointment. To schedule your COVID compliant showing call or text Chris Stein at 415-328-0792 Please use open escrow with Chicago Title Company, escrow officer Gerrie Brindley, escrow FWPN-3652100281-GB.
appliances__c, Dishwasher;Microwave;Free Standing Refrigerator;Free Standing Electric Range
architectural_style__c, Mediterranean
bath_features__c, Shower Stall(s);Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1937
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-06-04T22:49:29.000+0000
days_on_market__c, 775
dom__c, 13
ffd_description_pb, Stunning 1930s 3BR, 2.5BA standout in lovely Lone Mountain, directly across the street from Rossi Playground. A stately navy facade & gorgeous Spanish villa-like tiled steps lead to an evocative period interior of dark hw floors, carved crown molding & graceful architectural details. Grand showpiece living room w/lush west-facing park views & fireplace, posh formal dining room, relaxed open breakfast nook/sunny family room combo w/sliding door access to back deck/stairs to manicured garden below. An artfully updated kitchen w/crisp white & cobalt cabinets, white quartz counters & stainless appliances overlooks the garden's mature lemon & camellia trees. Softly curving stairs w/iron railing lead to oversized master suite w/fabulous dressing room & ensuite bath, two more bedrooms w/shared sitting area & sunlit garden views & second full bath. Garage w/versatile bonus guest room/office/gym & laundry room w/hookups. Easy walk to GG Park, Clement, Spanish Steps, and more!
district__c, SF District 1
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Wood Burning;Brick
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 2
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:54:21.000+0000
pba__latitude_pb__c, 37.7788913
pba__latitude_property__c, 37.7788913
laundry_features__c, In Garage;Hookups Only;Inside Area;Ground Floor;Sink
listed_date__c, 2020-12-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Dan
pba__listing_agent_lastname__c, Dodd
listing_agent_mls_id__c, 804303
ffd_listingagentname, Dan Dodd
listing_agent_number__c, 166013815
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, INSPIRE
listing_office_name__c, Inspire Real Estate
listing_office_number__c, 28583
pba__listingprice_pb__c, 2795000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=BuK5WPFsbiz&mls=1
pba__longitude_pb__c, -122.4561229
lower_level__c, Garage,Partial Bath(s)
mls_id__c, 421559619
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Shower Stall(s);Tub;Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-06-04
original_price__c, 2795000
overall_days_on_market__c, 88
parking_access__c, Tandem
parking_features__c, Enclosed,Garage Door Opener,Garage Facing Front,Interior Access,Tandem Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-06-17
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1029.9
pba__propertytype__c, Single Family Residence
id, a0E1I00000UTx8iUAD
room_type__c, Office;Bonus Room;Sun Room;Laundry;Kitchen;Living Room;Master Bathroom;Dining Room;Family Room;Master Bedroom
sale_date__c, 2021-07-06
sale_price__c, 3100000
security_features__c, Security Gate
selling_agent_mls_id__c, 803441
selling_agent_number__c, 803441
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 3010
size__c, 3010
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Rossi
subdist__c, Lone Mountain
ffd_name, 42 Rossi Avenue, San Francisco, CA, 94118
view__c, Park;Garden/Greenbelt
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1937
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530256737-1.jpg
ListingId, a0E1I00000UTx8iUAD