meta_query='key:subdist__c;value:Lone Mountain|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='327898' 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] => 2018-11-30 20:30:26
[post_modified_gmt] => 2018-11-30 20:30:26
[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, 4 Rossi Avenue, San Francisco, CA, 94118
ffd_mls_id, 423718383
ffd_salesforce_id, a0E8W00000a8GLmUAM
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 3
address2__c, 4 Rossi Avenue, San Francisco, CA, 94118
pba__address_pb__c, 4 Rossi Avenue, San Francisco, CA, 94118
agent_only_remarks__c, Go and show! Offer Date Tue 2/14/23 11am, see Disclosure Coversheet for offer instructions- HOA for unit 4 is $313 (Building Insurance/reserves)+ Operating expenses +/- $170 (water, trash, and common PG&E). Pre- Escrow opened with Yvette Gonzalez @ ORTC. Seller reserves the right to accept, counter, or refuse any offers. Buyer agrees to cooperate in sellers 1031 exchange at no cost, expense or liability to Buyer. Link to Disclosures: https://app.disclosures.io/link/4-Rossi-Avenue-l4jg99vx
appliances__c, Dishwasher;Microwave;Disposal;Free Standing Gas Oven;Free Standing Refrigerator;Ice Maker
architectural_style__c, Marina
bath_features__c, Tile;Window
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1941
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Frank Villanueva
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-01-30T20:46:27.000+0000
days_on_market__c, 46
dom__c, 15
ffd_description_pb, Discover the charm and convenience of city living in this spacious TIC located in the heart of San Francisco. Nestled on a picturesque corner lot in a vibrant neighborhood, this 3 bed/1.5 bath home is flooded with natural light. With beautiful hardwood floors throughout, the layout of this home creates a natural separation between the bedrooms and entertaining space. Perfect for hosting, the bright and airy living room features a fireplace, crown molding, and large windows on two sides of the room. A light-filled formal dining room and recently remodeled kitchen complete the living space. Down a hallway you'll find 3 bedrooms and 1.5 bathrooms. A serene private patio and direct access to an ensuite bathroom make the primary bedroom an ideal spot to unwind after a long day. A large front driveway allows for 2 car tandem parking with 1 spot in the garage and 1 in the driveway. With a high Walk Score of 93, enjoy all the shopping, dining, and entertainment options on Clement St, or take advantage of the Rossi Recreation Center, pool, and tennis courts just across the street.
district__c, SF District 1
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk,Sidewalk/Curb/Gutter
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard;Fenced
fireplace_features__c, Living Room;Wood Burning;Brick
pba__floortype_pb__c, Tile;Wood;Parquet
hoa_fee_includes__c, Common Areas,Electricity,Insurance,Maintenance Grounds,Sewer,Trash,Water
pba__hoafees__c, 483
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2023-03-17T10:48:35.000+0000
pba__latitude_pb__c, 37.7795707
pba__latitude_property__c, 37.7795707
laundry_features__c, In Basement;Washer Included;Dryer Included
listed_date__c, 2022-12-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Daniel
pba__listing_agent_lastname__c, Camou
listing_agent_mls_id__c, 815037
ffd_listingagentname, Daniel Camou
listing_agent_number__c, 1070145
listing_co_agent_mls_id__c, 804447
listing_co_agent_number__c, 166014010
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, 1495000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?brand=0&m=HiU18s2cJPy
pba__longitude_pb__c, -122.456492
lower_level__c, Garage
mls_id__c, 423718383
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Tub w/Shower Over;Tub;Tile;Soaking Tub;Window;Multiple Shower Heads
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-01-30
original_price__c, 1495000
overall_days_on_market__c, -81478
parking_access__c, Side by Side
parking_features__c, Assigned,Attached,Garage Door Opener,Private,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2023-02-14
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-03-16T16:54:27.000+0000
price_per_square_foot__c, 895.74
pba__propertytype__c, Tenancy In Common
ListingId, a0E8W00000a8GLmUAM
road_surface_type__c, Paved
roof__c, Composition
room_type__c, Storage;Kitchen;Living Room;Dining Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2023-03-16
sale_price__c, 1555000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, NMIRDAMR
selling_agent_number__c, 981389830
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Coldwell Banker Grass Roots Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1736
size__c, 1736
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Rossi
subdist__c, Lone Mountain
ffd_name, 4 Rossi Avenue, San Francisco, CA, 94118
website_property_type__c, Tenancy In Common
window_features__c, Dual Pane Partial
pba__yearbuilt_pb__c, 1941
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530574026-1.jpg