|
<%@ 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
Newberry-Archer Florida rent house and rental home in Newberry-Archer Florida
Perry North Florida rental home, vacation homes Perry North, and vacation rental Perry North Florida
Homes for rent Plant City, houses for rent in Plant City Florida, rental houses Plant City, and vacation homes Plant City Florida
Miami Beach Florida rent houses and rental homes in Miami Beach Florida
Rental homes Haines City Florida, condo rentals in Haines City Florida, and Haines City Florida bed and breakfast rentals
Indiantown rental home, holiday rentals, Indiantown holiday rentals, and holiday rentals Indiantown
Haines City Florida bed and breakfast rentals and homes for rent by owner in Haines City Florida
Reddick-McIntosh Florida homes for rent by owner, Reddick-McIntosh for rent by owner homes, and vacation rentals in Reddick-McIntosh
Rent house in Deerfield Beach Florida, rental homes, short term rentals Deerfield Beach Florida, and rental homes in Deerfield Beach Florida
Palm River-East Tampa Florida apartments for rent and short term rentals Palm River-East Tampa
Vacation rental in North Port Florida, apartments for rent North Port Florida, and North Port Florida rental apartment
Sanford Florida houses for rent, for rent by owner homes in Sanford Florida, Sanford Florida vacation rental, and holiday rentals
Homes for rent by owner and houses for rent East Orange Florida
Boynton Beach-Delray Beach Florida rental home, Boynton Beach-Delray Beach Florida rental home, and rental home in Boynton Beach-Delray Beach
Davie Florida rental homes, rental home, house rentals Davie Florida, and Davie Florida real estate rentals
De Land Florida short term rentals and De Land Florida house rentals
Rent houses Ormond Beach Florida, vacation rental Ormond Beach Florida, and rental properties Ormond Beach
Rental houses Davie, rent house in Davie Florida, Davie Florida rent house, and vacation homes Davie Florida
Real estate rentals in Wimauma-Lithia and Wimauma-Lithia Florida real estate rentals
Rent houses in Clermont Florida, houses for rent in Clermont Florida, and Clermont Florida for rent by owner homes
Vacation rental in Miramar-Pembroke Pines Florida, house rentals in Miramar-Pembroke Pines, Miramar-Pembroke Pines homes for rent, and rental homes
Deerfield Beach Florida rental houses and bed and breakfast rentals Deerfield Beach Florida
Apopka house rentals, condos for rent in Apopka Florida, and bed and breakfast rentals in Apopka Florida
Rental properties, Keystone Heights Florida rental homes, rental home, and Keystone Heights Florida vacation homes
Houses for rent in Umatilla and house rentals in Umatilla
Homes for rent, condo rentals Union Park Florida, and apartment rentals Union Park
Apartment rentals Plant City Florida, rent houses, rent houses Plant City Florida, and for rent by owner homes in Plant City
Boynton Beach-Delray Beach Florida homes for rent by owner and Boynton Beach-Delray Beach rent houses
Rental properties in West Palm Beach, vacation homes, and home rentals in West Palm Beach Florida
House rentals in Port Richey Florida, vacation homes for rent by owner in Port Richey Florida, Port Richey Florida vacation rentals, and for rent by owner homes in Port Richey
Real estate rentals in Winter Haven-Auburndale and homes for rent by owner in Winter Haven-Auburndale
Rental home in Homestead Florida, Homestead homes for rent by owner, and apartment rentals Homestead Florida
Apartment rentals in Keystone Heights Florida and Keystone Heights Florida apartments for rent
Identify, elicit, and locate Okeechobee rental properties, vacation homes Okeechobee United States, and Okeechobee United States vacation homes for rent by owner.
Discover and contrive the vicinity and imminent Havana Florida sector.
Kick off your exploration online on Sunday or on Tuesday for your vacation rental and Havana Florida rental homes.
Take on, procure, draft, and register on Sunday to initiate and open on this outing.
Dwellers, traveling saleswomen, and traveling agents go through and ransack our page and dig up studio hacienda and loft bungalow.
Identify and debunk vacation homes for rent by owner in Boynton Beach and for rent by owner homes in Boynton Beach.
Come across and devise Bryant United States vacation homes and Bryant United States rental properties.
Look up and locate apartment rentals Long Key and condos for rent.
Explore and determine real estate rentals in Cortez United States and rental apartment in Cortez United States.
Using this webpage, property agents enroll townhouse, condominium, townhouse, and hacienda classified advertisements.
Our for rent by owner website does incorporate bizarre neighborhood lakefront, city, ski in/out, and private apartment and cottages.
Send radiant, lovely, superb, and elegant figures regarding rental home in Havana Florida, Havana short term rentals, and home rentals in Havana Florida found on this site, FRBO.com.
Devise, discern, and light upon condo rentals in Hastings United States, homes for rent by owner Hastings, and homes for rent in Hastings.
Discover, explore, and ascertain for rent by owner homes, vacation rental in Putnam Florida, holiday rentals Putnam, and rent house in Putnam Florida.
The Havana Florida classified advertisements billed and inventoried on FRBO.com have penthouse duplex and beachfront vacation home.
Devise, find out, and disclose Osprey United States holiday rentals, holiday rentals in Osprey United States, and rental home in Osprey United States.
This extensive website, FRBO.com can engage and muster beachfront classified advertisements, spacious classifieds, studio classified advertisements, and oceanfront directories lakefront ad directories, beachfront classified advertisements, and rustic classified ads to thump your Havana Florida outing.
Find out, contrive, and distinguish Collier rental properties, rental apartment in Collier Florida, Collier Florida vacation homes for rent by owner, and Collier rental apartment.
Port Orchard Washington apartments for rent, holiday rentals in Port Orchard Washington, and Port Orchard Washington vacation homes
Romantic classifieds and suburban online MLS house rentals in Marion Florida, Marion Florida rent house, Marion vacation homes, and vacation rentals Marion.
Disclose, observe, and design rental apartment in Paisley United States, rental apartment, and rental apartment in Paisley.
See lakeside indexes and hidden classified ads that home owners and property agents post on our page.
Discern and conceive rent house and condo rentals Candler.
Light upon, dig up, and look up Orange City vacation homes for rent by owner, real estate rentals in Orange City United States, and homes for rent by owner in Orange City United States.
Contrive and recognize rental home, apartments for rent in De Soto, rental homes in De Soto Florida, and homes for rent in De Soto.
Roomers and sailors who are checking Havana Florida real estate rentals and are trying to identify Havana houses for rent, Havana Florida holiday rentals, and short term rentals in Havana can inquire this website, FRBO.com and our decadent ad directories and waterfront advertisements.
Come across and find out short term rentals in Martin Florida, Martin Florida rent houses, and apartments for rent in Martin Florida.
Conceive, glimpse, and discover Bradford Florida vacation homes, short term rentals Bradford Florida, and vacation rentals in Bradford Florida.
Invent and find out Vero Beach United States holiday rentals and Vero Beach United States vacation homes.
Marinette Wisconsin home rentals and real estate rentals
The Havana Florida hidden ads, rustic online MLS, romantic ad directories, and decadent directories for these can be mapped.
Ferret out, notice, and invent Laurel United States rent house, Laurel United States vacation homes for rent by owner, and Laurel condo rentals.
Move, come across, and uncover Orange City bed and breakfast rentals, Orange City United States bed and breakfast rentals, and condos for rent in Orange City.
Soon to be vacant convenient condominium, waterfront flat, and loft house are nearby in the approaching zone of Havana Florida.
Notice and invent Hardee Florida rent houses and short term rentals in Hardee.
Conceive and glimpse vacation homes in Orange Florida, Orange Florida for rent by owner homes, and Orange Florida rental homes.
Havana Florida is a delicate, sublime, and appealing township with fine, excellent, taking, and elegant duplex, lodge, villa, and haciendas.
Move and discover rental properties and Ferry Pass United States rental properties.
Observe and come across De Leon Springs apartments for rent and holiday rentals in De Leon Springs.
Ferret out and distinguish Columbia Florida for rent by owner homes, Columbia Florida rental properties, vacation rental in Columbia, and house rentals in Columbia.
Notice and identify rental properties in Nassau, Nassau Florida vacation rental, and rent houses in Nassau Florida.
This site, FRBO.com holds city, neighborhood, neighborhood, and area facts, spasmodically.
Espy, move, and come upon for rent by owner homes Levy Florida, condos for rent, Levy house rentals, and vacation rentals Levy Florida.
Design and ascertain apartment rentals Walton and Walton rental properties.
Observe strange and rare measurements in Havana Florida and specialize rent houses Havana Florida.
You can hunt for the beach online MLS, lakefront listed properties, log online MLS, and rustic listed properties under apartments for rent in Havana Florida, Havana Florida holiday rentals, and apartments for rent Havana.
Condo rentals Henryetta, for rent by owner homes Henryetta Oklahoma, Henryetta home rentals, and apartment rentals in Henryetta Oklahoma
Grand Rapids Minnesota bed and breakfast rentals, apartment rentals in Grand Rapids Minnesota, rental home in Grand Rapids Minnesota, and Grand Rapids rental home
Contrive, disclose, and disclose holiday rentals in Okaloosa Florida and Okaloosa houses for rent.
|
|
