Property Attributes
- MLS#645010
- TypeSingle Family
- Listing Status Pending
- CountyBoone
- CityUnion
- AreaRichwd-Un-Wal-Ver-SB
- NeighborhoodOrleans North
- Zip41091
- StyleTraditional
- Year Built2006
- Price$ 285,000
- Bedrooms3
- Full Bathrooms2
- Half Bathrooms1
- Sqr Footage1516
- Lot Size0.13 Acres
Data Source:
Northern Kentucky MLS (NKAR)
Property Description
Priced below market value, this home offers an incredible opportunity for instant equity! Whether you're a homeowner looking for value or an investor seeking your next opportunity, this property is one you won't want to miss. The seller is highly motivated and welcomes your offer! This beautiful two-story home in the desirable Orleans North Subdivision! Offering just over 1,500 square feet of living space, this home features an open floor plan that's perfect for both everyday living and entertaining. Large windows fill the home with natural light, creating a bright and inviting atmosphere. The entry, dining area, and kitchen feature durable laminate flooring for easy maintenance. Step outside to the patio overlooking the fenced backyard--ideal for relaxing, entertaining, or pets to play. Upstairs, you'll find the convenience of a second-floor laundry room along with a spacious primary suite featuring an adjoining private bath. Situated on a quiet cul-de-sac street, this home is within walking distance to the neighborhood park and just minutes from shopping, dining, and everyday conveniences. Don't miss your opportunity to make this wonderful home yours!
| Elementary School | Middle School | High School |
|---|---|---|
| Longbranch Elementary School | Ockerman Middle School Middle School | Cooper High School High School |
| Price History | |
|---|---|
| 7/24/2026 | Listed $292,000 |
| 7/30/2026 | 2$285,000 |
General Features
| Living Area | 1516 |
|---|---|
| Sewer | Public Sewer |
| Heating | Heat Pump |
| Cooling | Central Air |
| Utilities | Cable Available |
| Roof | Shingle |
| HOA Fee | 156.95 |
| Garage Spaces | 2 |
| Association Fee Includes | Association Fees,Maintenance Grounds |
| Patio/Porch Features | Covered,Patio,Porch |
| Architectural Style | Traditional |
| Construction Materials | Brick Veneer,Vinyl Siding |
| Year Built | 2006 |
| Levels | Two |
| Property Subtype | Single Family Residence |
| Assoc Fee Paid Per | Annually |
| County | Boone |
| New Construction | false |
| Property Type | Residential |
| HOA | true |
| Attached Garage | false |
| Subdivision Name | Orleans North |
| Garage Y/N | true |
| Total Rooms | 7 |
| Status | Pending |
| Directions | US 42 to Old Union road; West on Orleans Blvd; L on Long Branch, R on St. Louis; R on Rampart; L on Algiers; R on Carnival. |
| High School | Cooper High School |
| City | Union |
| Zoning Description | Residential |
| MLS Area | K11 - Richwd/Un/Wal/Ver/SB |
| Lot Size Units | Acres |
| Lot Size Square Feet | 5504 |
| Elementary School | Longbranch |
| Property Attached Y/N | false |
| Middle/Junior High School | Ockerman Middle School |
| Property Condition | Existing Structure |
| MLS Area Minor | K11 - Richwd/Un/Wal/Ver/SB |
| Structure Type | House |
| Standard Status | Pending |
Interior Features
| Interior Amenities | Laminate Counters,Walk-In Closet(s),Pantry,Open Floorplan,Multi Panel Doors |
|---|---|
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Vinyl Frames |
| Fireplace Y/N | false |
| Laundry Features | Laundry Room,Upper Level |
| Total Baths | 3 |
Exterior Features
| Fencing | Fenced |
|---|---|
| Parking Features | Driveway,Garage Faces Front,On Street |
| Lot Features | Cul-De-Sac |
| Water Source | Public |
| Lot Size Area | 0.13 |
| Foundation Details | Poured Concrete |
| Lot Dimensions | 99'54'125'34'27 |
| Lot Size Acres | 0.13 |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
The data relating to real estate for sale on this web site comes
in part from the Broker Reciprocity™ program of the Multiple
Listing Service of Greater Cincinnati. Real estate listings held by
brokerage firms other than Comey & Shepherd, REALTORS are marked with the MLS ™ logo
(the small logo to the left) and detailed information about them includes
the name of the listing brokers. The information herein is furnished by the property owner in
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawl. Neither listing broker(s) nor SE IN BD REALTORS shall be held responsible for typographical errors, misinformation, misprints and shall be held totally harmless.