Title Page Background
DEBUG FN args: Array ( [0] => 1785 [1] => [2] => [3] => agent ) BEFORE: Site: 1785 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1785 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1785 AND eai.ishudvalues = 1 AND m.expertType = 'agent' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1785 [1] => [2] => [3] => lender ) BEFORE: Site: 1785 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1785 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1785 AND eai.ishudvalues = 1 AND m.expertType = 'lender' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1785 [1] => [2] => [3] => other ) BEFORE: Site: 1785 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1785 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1785 AND eai.ishudvalues = 1 AND m.expertType = 'other' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;

434 Windover Ct
Melbourne, FL 32934

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $54,900
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1416 Square Feet
Agency: McCormick Home Sales Team LLC

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Refrigerator, Garbage Disposer
Architectural Style: Other
Construction Materials: Vinyl Siding
Cooling: Central A/C
Flooring: Laminate
Heating: Forced Air
Interior Features: Walk-in Closet, Laundry
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Dining Room, Laundry, Living Room, Gym

Window Features

Exterior Features: Pool Building
Parking Features: Garage, Carport
Roof: Asphalt
View: Lake
Waterfront Features: Waterfront, Wflake

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: Lamplighter Village

Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Other-Mobile Home
Year Built: 1982
Notes: Bonus, Bonus Located on a quiet cul-de-sac with a clear view of Lamplighter Village's largest lake, this partially furnished two-bedroom, two-bath home offers two bonus rooms. The first bonus room, located near the main entrance provides the perfect setting for an office, craft room, man cave, or even a third bedroom with bay windows overlooking the front yard. The other bonus room is an oversized second storage room, which includes several workbenches, ample natural lighting, and a door that opens to the backyard. There's a dedicated laundry room with complete hookups for a washer/dryer along with ample extra storage and cabinets. The dining room features a built-in buffet and light-colored wood look laminate flooring covers the entire home, with the kitchen and both bathrooms in linoleum tile. The large main bedroom includes a huge cedar-lined walk- in closet and the en-suite has a double-sink vanity. The covered screened carport lanai with sliding screen doors is a great outdoor living space. Attractively priced for quick sale. Don't delay, call today. Video showings are available for out-of-town buyers. About The Lamplighter Village Community Lamplighter Village is Melbourne's premier 55+ community that is loaded to the max with resort style amenities. Close to everything including river, ocean, shopping, hospital, restaurants, night life and much much more. Lot Fees $1023 Include - lawn, tree trim, trash, on site patrol, heated resort style pool and spa, fitness center, 18 hole miniature golf, pickle ball courts, bacci, shuffleboard, three clubhouses, ball room, dancing, waterfront dog park, ceramic studio and classes, computer biz center, billiards, bingo and bunco, lakefront card room, water front tiki bar for happy hours, water aerobics, yoga classes, line dancing, casino nights, drama club, 70+ social events every month, dinner dances and luncheons, mail box and light post at each home. NO PASS THROUGH OR ASSESSMENT FEES AS At THIS TIME.. PARK APPROVAL REQUIRED FEES APPLY. 55+ COMMUNITY PETS - NO AGGRESSIVE BREEDS BACKGROUND CHECK 3x lot rent in monthly verifiable income
MlsNumber: --


Listing Provided By: McCormick Home Sales Team LLC, original listing
Phone: (239) 247-2073
Office Phone: (239) 247-2073
Agent Name: Hilda Virgen
Disclaimer: Copyright © 2024 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App