meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='236123' 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, 37 Miraloma Drive, San Francisco, CA, 94127
ffd_mls_id, 422633191
ffd_salesforce_id, a0E8W00000WiBxSUAV
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 37 Miraloma Drive, San Francisco, CA, 94127
pba__address_pb__c, 37 Miraloma Drive, San Francisco, CA, 94127
agent_only_remarks__c, Please use standard 7-page SFAR Purchase Agreement. Seller kindly requests escrow remain with Liz Paglinawan with First American Title as one of the sellers may be out of the country during escrow. Disclosure package available upon request - please call, email or text listing agent. Half bath downstairs shows up on tax records. Various measurements for square footage include 1,462sf per appraisal, 1,405 per draftsperson, 1,130sf/1250sf per tax records. Buyer to verify to their satisfaction. Seller may need a longer escrow to close out final kitchen inspection.
appliances__c, Double Oven
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1926
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-04-29T17:48:36.000+0000
days_on_market__c, 446
dom__c, 5
ffd_description_pb, Ready to be smitten? This Tudor-style storybook home will have you swooning from its tasteful updates, gorgeous finishes, incredible layout, and undeniable curb-appeal. Fully detached and fit for entertaining, the sun-drenched living room welcomes you with a barreled ceiling and cozy fireplace. The brand new kitchen, a chef's dream with Viking appliances and built-in refrigerator, opens up into a stunning formal dining room finished with classical wainscoting. Three spacious bedrooms and an updated bathroom complete this level. The enchanting private backyard, with its beautifully done landscaping, expansive custom deck & fire-pit, is perfect for relaxing in the sun or entertaining your guests. Completing this home is a 2-car garage on the lower level with half bath, laundry and additional space ripe with expansion potential. Just blocks away from West Portal shops and restaurants, and ample public transit options. Add'l updates incl. electrical, HVAC system, EV charger & more!
district__c, SF District 4
entry_level__c, 0
exterior_features__c, Fire Pit
external_listing__c, 1
fencing__c, Back Yard;Fenced
fireplace_features__c, Other
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-05-25T10:48:40.000+0000
pba__latitude_pb__c, 37.7394468
pba__latitude_property__c, 37.7394468
laundry_features__c, In Garage
listed_date__c, 2022-02-21
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Brandi Lynne
pba__listing_agent_lastname__c, Mayo
listing_agent_mls_id__c, 811218
ffd_listingagentname, Brandi Lynne Mayo
listing_agent_number__c, 1050472
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7
listing_office_name__c, Compass
listing_office_number__c, 28751
pba__listingprice_pb__c, 1395000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.youtube.com/watch?v=DTI3_KiUkhQ
pba__longitude_pb__c, -122.4597617
lower_level__c, Garage,Partial Bath(s)
mls_id__c, 422633191
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-04-29
original_price__c, 1395000
overall_days_on_market__c, -81202
parking_access__c, Tandem
parking_features__c, Attached,Enclosed,EV Charging,Garage Door Opener
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2022-05-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-05-24T16:28:41.000+0000
price_per_square_foot__c, 1470.59
pba__propertytype__c, Single Family Residence
id, a0E8W00000WiBxSUAV
room_type__c, Storage;Kitchen;Living Room;Dining Room;Wine Storage Area
sale_date__c, 2022-05-24
sale_price__c, 2150000
selling_agent_mls_id__c, 806945
selling_agent_number__c, 166017922
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, 1462
size__c, 1462
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Miraloma
subdist__c, Miraloma Park
ffd_name, 37 Miraloma Drive, San Francisco, CA, 94127
view__c, Hills;Mountains;Sutro Tower
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1926
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530447849-1.jpg
ListingId, a0E8W00000WiBxSUAV
