Mackin
Book a Call
Sign in
Houston, TX

Mackin,
Market Edition.

Mackin — hyperlocal real-estate intelligence, published weekly.

Get in touch →

Cities

  • Houston, TX

Stories

  • What's new
  • Price drops
  • Luxury
  • Affordable
  • Open houses
  • Market reports

By price

  • Houston under $200k
  • Houston $200k to $400k
  • Houston $400k to $700k
  • Houston $700k to $1m
  • Houston over $1m

By type

  • Houston single-family homes
  • Houston condos
  • Houston land for sale
  • Browse all MLS
  • Map search
All city stories
Houston: what's newHouston: price dropsHouston: luxuryHouston: affordable
All city stories + every page → /sitemap
Mackin· Market Edition
InsightsJournalSearchMarketAboutReviewsFAQGuidesServices
Live MLS data via Repliers. Not for redistribution. © 2026
← Back to listing
For sale
$3,995,000
608 Little John
Houston, TX, 77024
MLS #40247052
5 beds
7 baths
7,241 sq ft
Built 1997

About this home

Enjoy living in Sherwood Forest in this gated, one owner custom-built showplace, perfectly situated on a private Close-in Memorial lane. A grand double staircase entry sets the tone for this stunning residence, where soaring ceilings, marble floors, and picturesque windows define the family friendly living and dining spaces. The newly remodeled wing features a spacious family room with designer lighting and a gas fireplace alongside a breathtaking island kitchen with a breakfast room, pantry, and coffee bar. The main-level owner's suite is a true retreat, with two studies, dual closets, and a spa-like bath. Upstairs, you'll find a media room, game room, and four generously sized guest suites, each with ensuite accommodations. Step outside to a serene backyard oasis with…

Houston market

Median sold
$314,793
Avg DOM
73 days
R
Dee Dee Guggenheim Howes
Compass RE Texas, LLC - Houston

Data via Repliers MLS API. Information deemed reliable but not guaranteed.