meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210521' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70665
[post_author] => 4
[post_date] => 2018-11-30 20:30:39
[post_date_gmt] => 2018-11-30 20:30:39
[post_content] => Storybook stucco charmers and mid-century modern masterpieces meander through this semi-circular neighborhood that fans out to the northeast, east, and southeast from the base of Mt. Davidson before coming to an abrupt stop at the top of Glen Canyon Park.
[post_title] => Miraloma Park
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => miraloma-park
[to_ping] =>
[pinged] =>
[post_modified] => 2023-10-30 17:01:45
[post_modified_gmt] => 2023-10-31 00:01:45
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70665
[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, 195 Los Palmos Drive, San Francisco, CA, 94127
ffd_mls_id, 497302
ffd_salesforce_id, a0E1I00000SiOdmUAF
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 195 Los Palmos Drive, San Francisco, CA, 94127
pba__address_pb__c, 195 Los Palmos Drive, San Francisco, CA, 94127
agent_only_remarks__c, I will ask that you sign the COVID entry form prior to going into the property. Please respect the rules for showing under the CDC and San Francisco Board of Realtors. Only showing agent by appointment and two potential buyers at one time as long as clients are from same family. Maintain 6 ft of distancing. Booties are provided on porch & Sanitizer wipes if you feel the need to use one. Please come with your own Mask and gloves Up to 4 cars off street can park. 2 in the driveway and 2 in the garage. Home has pest clearance. In very well maintained condition. I am happy to go to home and do a FaceTime showing or Zoom virtual showing for your buyer if you need. Just reach out to me. Property is Vacant so you can show your clients if prefer. ALL who enter property Must Wear Mask and gloves. Link to Disclosures iO. https://app.disclosures.io/link/195-Los-Palmos-Drive-eu2v64m1
appliances__c, Dishwasher;Gas Water Heater;Microwave;Disposal;Refrigerator;Hood Over Range;Cooktop Stove
architectural_style__c, Traditional;Ranch
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tile;Skylight/Solar Tube
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1963
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-04-29T10:46:27.000+0000
days_on_market__c, 1177
dom__c, 6
ffd_description_pb, Custom built back in the day, this Mid Century home is full of surprises. Exceptionally spacious and bright rooms through out. Lots of natural light floods the home as it is almost completely detached. The home lives almost like a ranch style, very few stairs to enter and live in the home. Gorgeous newly installed hardwood flooring in the living room, hallway & bedrooms. Imagine having friends/family over and enjoying the easy flow of the kitchen, dining and living room to the large wrap around redwood deck. Views to the south of the hills and neighborhood lights from the living room. The home has a bonus area in basement perhaps a great hobby area- work out or just storage. Huge 2 car side by side garage with work bench. Bonus 1/2 bath in garage. Home has a central vac system in place. Just one block away the Sunnyside Recreation Center with playground for those summer days. Easy access to freeway, Glen Park Bart Station and Ocean Ave. with Whole Foods, Library and Muni. Move in !
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
electric__c, 220 Volts in Kitchen
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Wood Burning;Raised Hearth
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-12T15:30:48.000+0000
pba__latitude_pb__c, 37.735812
pba__latitude_property__c, 37.735812
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-04-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Debbie
pba__listing_agent_lastname__c, Lamica
listing_agent_mls_id__c, 802290
ffd_listingagentname, Debbie Lamica
listing_agent_number__c, 802290
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, REMS
listing_office_name__c, RE/MAX Star Properties
listing_office_number__c, 199021441
pba__listingprice_pb__c, 1495000
pba__listingtype__c, Sale
pba__listing_website__c, https://listing.ewalk.com/bt/195_Los_Palmos_Dr.html
pba__longitude_pb__c, -122.44856
pba__lotsize_pb__c, 0.07
mls_id__c, 497302
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-04-28
original_price__c, 1495000
overall_days_on_market__c, 94
parking__c, Attached,Garage,Auto Door,Interior Access
parking_features__c, Attached,Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s);Patio(s)
pba__pendingdate__c, 2020-05-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 962.71
pba__propertytype__c, Single Family Residence
id, a0E1I00000SiOdmUAF
roof__c, Tar/Gravel
sale_date__c, 2020-05-29
sale_price__c, 1575000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 812906
selling_agent_name__c, Chrissy Luciano
selling_agent_number__c, 1058678
selling_co_agent_mls_id__c, 807821
selling_co_agent_name__c, Matthew J. Woebcke
selling_co_agent_number__c, 1027199
selling_co_office_mls_id__c, COMP7PAR
selling_co_office_name__c, Compass SF
selling_co_office_number__c, 27677
selling_office_name__c, Compass SF
pba__status__c, Closed
pba__totalarea_pb__c, 1636
size__c, 1636
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Los Palmos
subdist__c, Miraloma Park
ffd_name, 195 Los Palmos Drive, San Francisco, CA, 94127
transportation__c, 2 Blocks,3 Blocks
view__c, City Lights;Partial;Hills
website_property_type__c, Single Family Home
window_features__c, Window Coverings;Weather Stripped
pba__yearbuilt_pb__c, 1963
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/362437-1.jpg
ListingId, a0E1I00000SiOdmUAF