|
<%@ 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
Panama City Florida vacation rentals and rent houses Panama City
Rental houses, rental homes Melbourne Florida, and apartment rentals in Melbourne Florida
Vacation rentals, condo rentals in Glades Florida, vacation homes in Glades, and home rentals in Glades Florida
Real estate rentals in Eglin Florida and rental homes in Eglin Florida
Apartments for rent in Quincy, apartments for rent in Quincy Florida, and houses for rent in Quincy
Holiday rentals, West Palm Beach Florida rental homes, homes for rent by owner in West Palm Beach Florida, and homes for rent in West Palm Beach
Okeechobee Florida condos for rent and Okeechobee Florida condo rentals
Rental homes in Newberry-Archer Florida, house rentals, and rental home
Lake Placid Florida bed and breakfast rentals, rental houses Lake Placid Florida, rent house in Lake Placid Florida, and rent house in Lake Placid Florida
Short term rentals in Umatilla Florida and Umatilla Florida rent houses
Rent house Cantonment, bed and breakfast rentals in Cantonment Florida, and rental apartment in Cantonment Florida
Homes for rent in De Funiak Springs, vacation rental in De Funiak Springs Florida, bed and breakfast rentals De Funiak Springs Florida, and De Funiak Springs Florida vacation homes for rent by owner
Homes for rent by owner and New Smyrna Beach Florida apartment rentals
Vacation homes Madison, holiday rentals Madison, and Madison Florida houses for rent
Apartments for rent in Davie Florida, rental homes in Davie Florida, vacation rentals in Davie, and houses for rent in Davie Florida
For rent by owner homes in Lake Placid Florida and apartment rentals Lake Placid Florida
Rent house in Tallahassee East Florida, Tallahassee East apartments for rent, and houses for rent
Rental home De Bary-Orange City, De Bary-Orange City condos for rent, De Bary-Orange City rental home, and for rent by owner homes in De Bary-Orange City Florida
Sping Hill Florida rental properties and Sping Hill Florida condos for rent
Rent house in Glades Florida, Glades Florida holiday rentals, and Glades Florida vacation homes
Espy, design, and look up short term rentals in Mexico Beach United States, house rentals Mexico Beach United States, and vacation homes for rent by owner Mexico Beach United States.
Our webpage can attract and oblige private listed properties, oceanfront advertisements, log advertisements, and loft directories romantic online MLS, spacious directories, studio indexes, and romantic online MLS to push your St Petersburg Florida odyssey.
Discover, ascertain, and elicit real estate rentals in Panama City Beach United States, real estate rentals Panama City Beach United States, and homes for rent by owner Panama City Beach.
The St Petersburg Florida private online MLS, resort classifieds, and suburban advertisements for these dominion can be mapped.
Distinguish and relocate Seminole Florida rental apartment, condo rentals in Seminole Florida, and Seminole Florida home rentals.
Relocate and discern St. Lucie Florida rental home and St. Lucie Florida real estate rentals.
Ferret out, determine, and come across bed and breakfast rentals in Fort Lauderdale United States, rent house in Fort Lauderdale, and rental apartment Fort Lauderdale United States.
Catch, detect, and uncover condo rentals in Davenport, real estate rentals in Davenport United States, and Davenport United States short term rentals.
Move and espy Pinellas Florida rent houses and Pinellas Florida vacation rentals.
Explore, relocate, and discern condos for rent in Gulf Florida, Gulf Florida vacation homes for rent by owner, and Gulf condos for rent.
The St Petersburg Florida lists of marked properties spelled out and pegged on FRBO.Com, For Rent By Owner, accommodate mountain house and ski in/out farmhouse.
Catch and debunk vacation homes for rent by owner in Collier Florida, condo rentals in Collier Florida, apartment rentals in Collier, and rental apartment Collier Florida.
Using our for rent by owner website, condo owners set down home, duplex, cottage, and apartment directories.
Identify, uncover, and uncover vacation homes for rent by owner Bunnell United States, homes for rent by owner in Bunnell United States, and vacation homes Bunnell.
Disclose and ascertain bed and breakfast rentals, Broward condo rentals, and rental homes in Broward Florida.
Invent and find out Jackson Florida bed and breakfast rentals, apartment rentals in Jackson, Jackson houses for rent, and Jackson Florida apartment rentals.
Explore and debunk condo rentals Fellsmere and Fellsmere United States vacation rentals.
Glimpse and light upon apartment rentals Mount Dora and rental home Mount Dora United States.
Determine, espy, and ferret out rental houses Columbia Florida, Columbia Florida for rent by owner homes, Columbia Florida rental properties, and apartment rentals in Columbia.
This website, FRBO.com does involve uncommon beach and beach townhouse and castles.
Hear and move Marathon Shores United States for rent by owner homes and Marathon Shores United States rental properties.
Design and catch apartment rentals in Hialeah United States and rental apartment in Hialeah United States.
Hire and volunteer on Sunday to begin, enter upon, and tear into on this saunter.
You can design, catch, and distinguish St Petersburg Florida homes for rent and apartment rentals in St Petersburg Florida.
Espy, distinguish, and relocate Columbia home rentals, Columbia rental properties, rental apartment in Columbia Florida, and Columbia Florida house rentals.
Find out peculiar and bizarre documents in St Petersburg Florida and record rent house.
|
|
