meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='234139' 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, 37 Miraloma Drive, San Francisco, CA, 94127
ffd_mls_id, 477744
ffd_salesforce_id, a0E1I000004u2A7UAI
address2__c, 37 Miraloma Drive, San Francisco, CA, 94127
pba__address_pb__c, 37 Miraloma Drive, San Francisco, CA, 94127
agent_only_remarks__c, Offers 11-01-18 at 12 noon please. This is a probate sale not subject to court confirmation. Buyers please cooperate with probate timing. Easy to show. text me at 415-867-7373. House needs TIC. Pre escrow opened with Fidelity National Title. Escrow officer: Sam Saravia 415-563-3500 ext. 205
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1926
pba__city_pb__c, San Francisco
ffd_createddate, 2018-10-30T19:53:15.000+0000
days_on_market__c, 1736
dom__c, 15
ffd_description_pb, Welcome to this beautiful and fully detached home in Miraloma Park. The main level features a formal living room with a fireplace, a lovely dining room, a kitchen that is waiting to be upgraded to your taste, three spacious bedrooms and a brand new bathroom. Hardwood floors throughout the entire living space. The large, fenced in, back yard is ideal for children and pets! The lower level is waiting to be developed. Two car parking. Enclosed garage and close to public transportation and freeways 101 and 280. Proximity to urban hiking trails eg. Mt. Davidson, public transportation, restaurants and shopping. Lot's of potential to make this home fit your needs.
district__c, SF District 4
external_listing__c, 1
hoa_dues__c, 0
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2022-03-01T20:29:31.000+0000
pba__latitude_pb__c, 0.000000
pba__latitude_property__c, 0.000000
listed_date__c, 2018-10-17
pba__listing_agent_firstname__c, Ilona
pba__listing_agent_lastname__c, Edwards-Marsovszk
listing_agent_mls_id__c, 804012
listing_agent_number__c, 166013409
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, MCGU05
listing_office_name__c, McGuire Real Estate
listing_office_number__c, 166014082
pba__listingprice_pb__c, 1250000
pba__listingtype__c, Sale
pba__listing_website__c, http://cid:96501AC6-3A8D-46AC-AC05-2155F9280A46/F688414A-2E02-4A5A-9D59-015427B88959
pba__longitude_pb__c, 0.000000
pba__lotsize_pb__c, 0.08
mls_id__c, 477744
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2018-10-17
original_price__c, 1250000
overall_days_on_market__c, 1736
parking__c, Garage,Interior Access
parking_type__c, On Site
price_per_square_foot__c, 1120
pba__propertytype__c, Single-Family Home
id, a0E1I000004u2A7UAI
sale_date__c, 2019-04-30
sale_price__c, 1400000
selling_agent_mls_id__c, 811218
selling_agent_name__c, Brandi Lynne Mayo
selling_agent_number__c, 1050472
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass SF
pba__status__c, Closed
pba__totalarea_pb__c, 1250
size__c, 1250
pba__state_pb__c, CA
pba__street_pb__c, Miraloma
subdist__c, Miraloma Park
ffd_name, 37 Miraloma Drive, San Francisco, CA, 94127
transportation__c, 1 Block
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/343816-1.jpg
ListingId, a0E1I000004u2A7UAI
