meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237237' 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, 453 Teresita Boulevard, San Francisco, CA, 94127
ffd_mls_id, 422659854
ffd_salesforce_id, a0E8W00000WkmG8UAJ
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 453 Teresita Boulevard, San Francisco, CA, 94127
pba__address_pb__c, 453 Teresita Boulevard, San Francisco, CA, 94127
agent_only_remarks__c, Disclosure package available after 6/8. Available after by request. Escrow opened with Heather Shiffer, First American Title. Offers as they come. All offers on SFAR contract please with Preapproval Letter, proof of funds. See disclosures for more info. Bath and office down may not be warranted. Call John 415.999.9827 with any questions or to discuss. NOTE: Missed tour for 4/14 but will be open 2-4 and always on Supra.
appliances__c, Dishwasher;Free Standing Gas Oven
architectural_style__c, Mid-Century
bath_features__c, Shower Stall(s);Tub;Tile;Window
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1939
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-06-04T18:47:14.000+0000
days_on_market__c, 410
dom__c, 31
ffd_description_pb, Open Sat/Sun 2-4:30. Lovely Art Deco, Miraloma Park center patio w/views over the Canyon and great light throughout. Spacious living room w/ fireplace west facing picture windows, good sized formal dining room, breakfast room and lovely Art Deco kitchen. Full lovely tiled bath w/sep tub & shower and two good sized bedrooms overlooking the large flat yard and Canyon. Downstairs is an extra large bedroom, newly renovated full bath and unique glass walled office space. There is a large 1 plus garage with storage and laundry. Below this level is a huge open storage area with plenty of room for potential expansion. In back is a large level yard with mature plantings. Located in the super popular Miraloma Park neighborhood, with great schools and quick access to tons of fund villages like West Portal, Glen Park, Noe Valley and the Inner Sunset. Property comes w/solar panels, Tesla Power Wall, plug for Electric cars. Numerous system upgrades including roof, heating, electrical and more.
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
electric__c, 220 Volts in Laundry,Battery Backup,Photovoltaics Seller Owned
entry_level__c, 0
exterior_features__c, Uncovered Courtyard
external_listing__c, 1
fencing__c, Back Yard;Wood
fireplace_features__c, Living Room;Brick
pba__floortype_pb__c, Linoleum;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2023-07-13T17:10:19.000+0000
pba__latitude_pb__c, 37.740103
pba__latitude_property__c, 37.740103
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2022-05-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, Woodruff
listing_agent_mls_id__c, 239976
ffd_listingagentname, John L Woodruff III
listing_agent_number__c, 239976
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, AETHOS
listing_office_name__c, Aethos Real Estate
listing_office_number__c, 27302
pba__listingprice_pb__c, 1599000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=3VbZds5Zsv7
pba__longitude_pb__c, -122.447763
lower_level__c, Bedroom(s),Full Bath(s),Garage
mls_id__c, 422659854
main_level__c, Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-06-04
original_price__c, 1599000
overall_days_on_market__c, -81238
parking_access__c, Independent
parking_features__c, Attached,Covered,Garage Door Opener,Garage Facing Front,Interior Access,Workshop in Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-07-05
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 841.81
pba__propertytype__c, Single Family Residence
record_id, a0E8W00000WkmG8UAJ
road_surface_type__c, Paved
room_type__c, Office;Kitchen;Living Room;Dining Room;Workshop;Primary Bathroom
sale_date__c, 2022-07-26
sale_price__c, 1655000
selling_agent_mls_id__c, 812613
selling_agent_number__c, 1057379
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Mosaik Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1966
size__c, 1966
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Teresita
subdist__c, Miraloma Park
ffd_name, 453 Teresita Boulevard, San Francisco, CA, 94127
view__c, Park;Twin Peaks;Mountains;Canyon
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1939
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530459016-1.jpg
ListingId, a0E8W00000WkmG8UAJ