meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214511' 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] => 2024-04-11 08:26:13
[post_modified_gmt] => 2024-04-11 15:26:13
[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, 145 Juanita Way, San Francisco, CA, 94127
ffd_mls_id, 505216
ffd_salesforce_id, a0E1I00000THdeYUAT
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 145 Juanita Way, San Francisco, CA, 94127
pba__address_pb__c, 145 Juanita Way, San Francisco, CA, 94127
agent_only_remarks__c, Offers, if any, due Friday, Sept 11 at noon. Garage may fit 2 small car plus an additional car in the driveway. Right Rear Room on Ground Level of this home is not Warranted as Living Space, but is included in sq. ft.
architectural_style__c, Spanish/Med
bath_features__c, Tub w/Shower Over;Shower Stall(s);Granite
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1927
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-09-04T19:46:01.000+0000
days_on_market__c, 1048
dom__c, 7
ffd_description_pb, Located in the heart of Old Miraloma Park, a tranquil, convenient and coveted neighborhood, this stunning 4-bedroom, 2-bathroom Spanish Mediterranean home awaits you. With 2 levels of generous living space, the main level of the home boasts gorgeous original details including crown moldings, coved ceilings and a wood burning fireplace. Two large bedrooms, an adjacent full bathroom as well as an updated kitchen, formal dining room and living room complete this floor. Downstairs boasts two additional bedrooms, 1 full bathroom, and a den or office with sliding doors that lead to the sun-drenched rear patio and back yard. Away from the hustle and bustle of the city, but in close proximity to hiking in Glen Canyon Park and Mt. Davidson, shopping and dining on West Portal and easy access to the freeway and public transit.
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
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas
ffd_lastmodifieddate, 2022-01-25T15:33:23.000+0000
pba__latitude_pb__c, 37.7426162
pba__latitude_property__c, 37.7426162
laundry_features__c, Inside Room
listed_date__c, 2020-09-04
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mary Lou
pba__listing_agent_lastname__c, Castellanos
listing_agent_mls_id__c, 301994
ffd_listingagentname, Mary Castellanos
listing_agent_number__c, 301994
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 1895000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/454355671
pba__longitude_pb__c, -122.4542083
pba__lotsize_pb__c, 0.08
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 505216
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-09-04
original_price__c, 1895000
overall_days_on_market__c, 87
parking__c, Attached,Garage,Auto Door,Interior Access,Guest Space(s)
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Guest Parking Available,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Patio(s)
pba__pendingdate__c, 2020-09-11
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 898.59
pba__propertytype__c, Single Family Residence
id, a0E1I00000THdeYUAT
room_type__c, Laundry;Den
sale_date__c, 2020-10-06
sale_price__c, 2100000
selling_agent_mls_id__c, 813002
selling_agent_name__c, Tracy Hsieh
selling_agent_number__c, 1058962
selling_co_agent_mls_id__c, 808482
selling_co_agent_name__c, Michael Minson
selling_co_agent_number__c, 1035858
selling_co_office_mls_id__c, KWRSF
selling_co_office_name__c, Keller Williams San Francisco
selling_co_office_number__c, 26158
selling_office_name__c, Keller Williams San Francisco
pba__status__c, Closed
pba__totalarea_pb__c, 2337
size__c, 2337
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Juanita
subdist__c, Miraloma Park
ffd_name, 145 Juanita Way, San Francisco, CA, 94127
transportation__c, 4+ Blocks
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1927
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/369638-1.jpg
ListingId, a0E1I00000THdeYUAT