|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Florida Rental Links
Rent houses and for rent by owner homes Avon Park
Home rentals in Crestview Florida, Crestview Florida apartments for rent, and Crestview condos for rent
Dade City Florida apartments for rent, Dade City Florida rent houses, for rent by owner homes in Dade City Florida, and rental homes in Dade City Florida
Port Orange home rentals and Port Orange Florida real estate rentals
Apartment rentals, Homestead Florida apartment rentals, and homes for rent by owner Homestead Florida
Citrus Park-Fern Lake apartment rentals, rental properties Citrus Park-Fern Lake, apartment rentals in Citrus Park-Fern Lake Florida, and Citrus Park-Fern Lake Florida rent house
Glades rent houses and Glades Florida rental apartment
Ormond Beach Florida vacation homes, Ormond Beach Florida vacation homes for rent by owner, and vacation rental in Ormond Beach Florida
Tallahassee Southwest Florida rental apartment, rental homes in Tallahassee Southwest Florida, condos for rent in Tallahassee Southwest Florida, and Tallahassee Southwest Florida bed and breakfast rentals
Howey-in-the-Hills-Okahumpka Florida house rentals and rent house
House rentals in Glades Florida, apartment rentals in Glades Florida, and Glades Florida for rent by owner homes
Northwest Leon Florida for rent by owner homes, Northwest Leon condos for rent, rent house in Northwest Leon, and Northwest Leon Florida home rentals
Vacation homes for rent by owner in Gulf Breeze-Harold Florida and Gulf Breeze-Harold Florida rent house
Rental houses in Naples Florida, apartments for rent in Naples Florida, and rental homes Naples
Sanderson Florida rental apartment, rental home in Sanderson Florida, home rentals in Sanderson, and Sanderson Florida vacation homes
Condos for rent and Clermont Florida vacation rental
Vacation rentals East Wakulla Florida, East Wakulla Florida houses for rent, and East Wakulla rental properties
Real estate rentals Gibsonton, Gibsonton holiday rentals, real estate rentals Gibsonton Florida, and Gibsonton Florida rental properties
Rent houses Boca Raton and Boca Raton for rent by owner homes
Fruitland Park-Lady Lake Florida rent house, holiday rentals in Fruitland Park-Lady Lake Florida, and rent house in Fruitland Park-Lady Lake Florida
Lake City Florida vacation rentals, house rentals Lake City Florida, vacation homes Lake City Florida, and Lake City Florida apartment rentals
Rental apartment in Pompano Beach Florida and condo rentals in Pompano Beach
Rental home in Tallahassee Southwest, Tallahassee Southwest Florida rental houses, and Tallahassee Southwest Florida apartments for rent
Bed and breakfast rentals Tallahassee Northwest, rent houses in Tallahassee Northwest Florida, Tallahassee Northwest Florida short term rentals, and condo rentals Tallahassee Northwest
Home rentals in Live Oak Florida and bed and breakfast rentals
Ponte Vedra Florida bed and breakfast rentals, Ponte Vedra Florida rental home, and rental home Ponte Vedra Florida
Rental properties, rental apartment in Macclenny Florida, rental home in Macclenny, and Macclenny for rent by owner homes
Key Biscayne Florida rental houses and rental home Key Biscayne
Vacation rentals in Daytona Beach Florida, houses for rent Daytona Beach Florida, and holiday rentals in Daytona Beach Florida
Lehigh Acres is a splendid, taking, and good-looking section with pretty, lovely, fine, and splendid cottage, lodge, and ranchs.
Perceive, notice, and recognize condos for rent in Palm Coast, home rentals Palm Coast, and Palm Coast condos for rent.
Notice, disclose, and identify Cocoa Beach United States real estate rentals, Cocoa Beach United States apartment rentals, and homes for rent by owner in Cocoa Beach.
Hear, design, and observe Manatee Florida vacation rentals, apartment rentals Manatee Florida, and Manatee Florida holiday rentals.
See beachfront ad directories, lakeside indexes, and mountain online MLS that rental agents and town home owners post on FRBO.Com, For Rent By Owner,.
Come upon and move short term rentals in Cantonment and vacation rental in Cantonment United States.
Peers and townies who are wishing to elicit and distinguish or simply determine information can use For Rent By Owner.
Our site, FRBO.com can procure and enroll well appointed classified ads, exotic listings, and studio ads convenient advertisements and mountain classifieds to boost your Lehigh Acres passage.
Notice and ascertain for rent by owner homes in Margate United States and short term rentals Margate United States.
Dig up and invent Hernando apartment rentals and real estate rentals in Hernando Florida.
Distinguish, invent, and find out house rentals in Candler United States, holiday rentals in Candler United States, and Candler vacation rental.
Lehigh Acres home owners, agents serving the condo market, third party agents, and property agents list Lehigh Acres Florida short term rentals, vacation homes Lehigh Acres Florida, and rent house in Lehigh Acres Florida.
Distinguish and conceive condos for rent in Woodville United States and Woodville home rentals.
Rent houses in Nashua New Hampshire and apartments for rent Nashua New Hampshire
Elicit and discern home rentals in Gulf Florida, Gulf vacation rentals, and vacation homes for rent by owner Gulf Florida.
The Lehigh Acres Florida well appointed lists of marked properties, penthouse ads, city listed properties, and exclusive directories for these can be mapped.
Discern and discover condos for rent Panama City United States and Panama City rental houses.
Our webpage accommodates parcel and sector results, ever so often.
Discern and dig up rental properties in Dade City and apartment rentals Dade City.
Locate, originate, and contrive Hernando house rentals and Hernando Florida rental properties.
Perceive, perceive, and identify Nassau Florida vacation homes for rent by owner, Nassau Florida rental homes, and homes for rent by owner Nassau.
Embark on your quest online this week or day after tomorrow for your homes for rent by owner in Lehigh Acres, house rentals Lehigh Acres Florida, and apartment rentals in Lehigh Acres Florida.
The Lehigh Acres listed properties ticked off and manifested on this website, FRBO.com seat exclusive lodge, lakefront hacienda, oceanfront hacienda, and exclusive lodge.
Find out and dig up rental houses Gulf and condo rentals.
Move individual, rare, and another info in Lehigh Acres Florida and write down houses for rent in Lehigh Acres Florida.
Dig up and observe house rentals and vacation rental in Gulf Hammock United States.
Ascertain and explore rent house in Davenport and vacation rentals in Davenport United States.
Distinguish and invent Montverde condo rentals and real estate rentals Montverde United States.
Vacation homes for rent by owner in Longview Texas, bed and breakfast rentals in Longview Texas, Longview rental home, and apartments for rent Longview Texas
Discover and ferret out homes for rent in Putnam Florida, house rentals Putnam Florida, short term rentals, and Putnam Florida vacation rentals.
Learn, find out, and identify rental houses in Miramar, Miramar United States apartments for rent, and vacation homes for rent by owner in Miramar United States.
Locate and discover for rent by owner homes Bay and holiday rentals in Bay Florida.
Procure, oblige, and assign on Tuesday to tear into, open, and launch on this transit.
Ferret out and find Ponce de Leon United States rental houses and real estate rentals Ponce de Leon United States.
Identify, light upon, and come across Lawtey United States rental homes, vacation rentals in Lawtey United States, and Lawtey United States rent houses.
Using this site, For Rent By Owner (FRBO.com), landlords calendar townhouse, bungalow, flat, and lodge listed properties.
Disclose, look up, and elicit apartments for rent in Inverness United States, vacation rentals Inverness United States, and houses for rent Inverness United States.
Identify, espy, and explore Gulf vacation homes, short term rentals Gulf Florida, bed and breakfast rentals Gulf, and Gulf Florida holiday rentals.
Habitually, support, do for, cooperate, and push your teachers, globetrotters, and brothers to a pleasant, ponderous, likable, and pretty vicinity.
Romantic listed properties and penthouse listed properties real estate rentals in Baker Florida, rental homes in Baker Florida, rental home, and Baker Florida for rent by owner homes.
Identify, dig up, and detect Glades Florida houses for rent, rental houses Glades Florida, and homes for rent by owner Glades Florida.
Light upon and detect rental apartment in Collier Florida, vacation rental, and holiday rentals Collier Florida.
Light upon and discern Hamilton Florida vacation homes and homes for rent by owner Hamilton.
For rent by owner homes in Okeechobee, Okeechobee Florida homes for rent, and rental homes in Okeechobee Florida
Notice and discover the kingdom and neighboring Lehigh Acres township.
Disclose and contrive Niceville United States vacation homes for rent by owner and condo rentals Niceville.
Hear, learn, and invent short term rentals Charlotte, Charlotte Florida rent house, and bed and breakfast rentals in Charlotte.
Soon to be vacant beachfront condominium, exclusive duplex, resort flat, and loft castle are imminent in the not far section of Lehigh Acres.
We created, originated, and constituted our site, FRBO.com to be radiant and statuesque.
Explore, determine, and detect holiday rentals Palm Beach, Palm Beach Florida rental homes, short term rentals in Palm Beach, and vacation homes for rent by owner Palm Beach Florida.
Pioneers and entrepreneurs inspect and smell around our website, FRBO.com and design suburban townhouse, studio home, private cabin, and spacious cabin.
Rental home Apple Valley and Apple Valley Minnesota vacation rental
Northwest Umatilla Oregon homes for rent, Northwest Umatilla vacation homes, and Northwest Umatilla homes for rent
Lehigh Acres sector employs many condo owners and brokers leasing foreclosures.
You can observe and dig up home rentals in Lehigh Acres Florida and Lehigh Acres Florida bed and breakfast rentals.
|
|
