meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218463' 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, 666 Rockdale Drive, San Francisco, CA, 94127
ffd_mls_id, 421541441
ffd_salesforce_id, a0E1I00000UTWXzUAP
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 666 Rockdale Drive, San Francisco, CA, 94127
pba__address_pb__c, 666 Rockdale Drive, San Francisco, CA, 94127
agent_only_remarks__c, Coming soon. Sellers are open to showing and selling while they are occupying the property. Move out date planned for mid June. Showings will start in one week. Please call for more info. Disclosures are being prepared and inspections are scheduled for May 6th.
appliances__c, Dishwasher;Hood Over Range;Built-In Gas Range
architectural_style__c, Spanish;Mediterranean
bath_features__c, Tub w/Shower Over;Shower Stall(s);Double Sinks
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1930
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-05-21T16:48:05.000+0000
days_on_market__c, 789
dom__c, 0
ffd_description_pb, Beautifully updated 4BR, 2BA, detached 1930's Spanish-Mediterranean offering style and serenity with a park-like yard in coveted Miraloma Park. The warm interior offers period details, including arched doorways, coved ceilings and dark wood floors. The spacious LR has a stucco fireplace and bay windows; the formal DR has a curved ceiling. Classic kitchen with SS appliances, white subway-tile backsplash, gray countertops and a sunny, windowed breakfast nook. The flexible 4BR floor plan is perfect for live/work under one roof with 2 BR and a remodeled BA on each level. A fabulous deck off of the lower level leads to the flat, grassy, park-like backyard - ideal for California living. Blending the best of old and new, this charming, lovingly maintained home with serene outlooks is waiting to welcome you. 1 car garage, separate laundry room + ample storage space. Family-friendly Miraloma Park is surrounded by top schools and proximity to shops, restaurants, transit and nature.
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced
pba__floortype_pb__c, Other;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:50:32.000+0000
pba__latitude_pb__c, 37.7411283
pba__latitude_property__c, 37.7411283
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2021-04-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tiffany
pba__listing_agent_lastname__c, Hickenbottom
listing_agent_mls_id__c, 807832
ffd_listingagentname, Tiffany Hickenbottom
listing_agent_number__c, 1027421
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP2
listing_office_name__c, Compass
listing_office_number__c, 27341
pba__listingprice_pb__c, 1899000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.450506
lower_level__c, Bedroom(s),Master Bedroom
mls_id__c, 421541441
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Dining Room;Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-05-21
original_price__c, 1899000
overall_days_on_market__c, 118
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-05-21
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1056.7
pba__propertytype__c, Single Family Residence
id, a0E1I00000UTWXzUAP
room_type__c, Laundry;Kitchen;Master Bedrooms 2+;Dining Room;Family Room;Other
sale_date__c, 2021-05-28
sale_price__c, 2050000
selling_agent_mls_id__c, 804090
selling_agent_number__c, 166013532
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 1940
size__c, 1940
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Rockdale
subdist__c, Miraloma Park
ffd_name, 666 Rockdale Drive, San Francisco, CA, 94127
view__c, City;Garden/Greenbelt;Mountains
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1930
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530224932-1.jpg
ListingId, a0E1I00000UTWXzUAP