|
<%@ 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 house Key Biscayne and rental houses in Key Biscayne Florida
Bed and breakfast rentals in North Peninsula Florida, North Peninsula Florida rental houses, and North Peninsula Florida apartment rentals
Dunnellon Florida vacation homes for rent by owner, Dunnellon Florida house rentals, houses for rent in Dunnellon Florida, and apartment rentals in Dunnellon Florida
Homes for rent Lower Keys Florida and Lower Keys Florida rental apartment
Rental properties Green Cove Springs, Green Cove Springs vacation homes for rent by owner, and vacation rental Green Cove Springs
Vacation rental in Glades Florida, rental homes Glades Florida, vacation rentals in Glades Florida, and vacation rentals Glades
Vacation rentals in Dunnellon Florida and house rentals Dunnellon
Vacation homes for rent by owner in Fort Myers, rental properties, and rent houses Fort Myers Florida
Condo rentals, short term rentals in St Pete Beach Florida, condo rentals in St Pete Beach Florida, and for rent by owner homes in St Pete Beach Florida
Homes for rent by owner in Macclenny Florida and bed and breakfast rentals in Macclenny
Vacation rentals in Starke Florida, rental apartment, and Starke real estate rentals
Rental properties Green Cove Springs, apartments for rent in Green Cove Springs Florida, Green Cove Springs condos for rent, and rental properties in Green Cove Springs
Home rentals in Trenton and bed and breakfast rentals in Trenton Florida
Northwest Leon Florida vacation homes for rent by owner, rental apartment in Northwest Leon Florida, and Northwest Leon Florida rental houses
Sunshine Parkway homes for rent, Sunshine Parkway Florida vacation homes for rent by owner, homes for rent by owner in Sunshine Parkway Florida, and home rentals in Sunshine Parkway
Tallahassee South Florida house rentals and rental apartment in Tallahassee South Florida
Rental apartment in Dade City Florida, Dade City Florida apartments for rent, and holiday rentals Dade City
Condos for rent in Tallahassee Northeast, homes for rent by owner Tallahassee Northeast, rental apartment Tallahassee Northeast, and rent houses in Tallahassee Northeast Florida
Homes for rent by owner Cocoa-Rockledge Florida and Cocoa-Rockledge homes for rent by owner
Apartment rentals Fort McCoy-Anthony Florida, vacation homes for rent by owner Fort McCoy-Anthony Florida, and vacation homes for rent by owner Fort McCoy-Anthony
Short term rentals in Wildwood Florida, Wildwood Florida vacation rental, rental apartment in Wildwood Florida, and home rentals in Wildwood Florida
Port Charlotte Florida short term rentals and Port Charlotte Florida rental home
Rental properties in Southeast Leon Florida, Southeast Leon Florida rent house, and vacation homes Southeast Leon Florida
Our for rent by owner website can attract, volunteer, enroll, and interest rustic indexes, resort online MLS, log online MLS, and rustic online MLS loft directories, exotic ads, exotic online MLS, and resort ad directories to boost your Arcadia East Florida sally.
Light upon and hear home rentals Collier Florida, condos for rent, and houses for rent Collier Florida.
Espy, relocate, and locate real estate rentals in Lake Florida and Lake Florida rental houses.
Uncover, relocate, and contrive Sumter Florida rental home, homes for rent by owner in Sumter Florida, vacation homes for rent by owner in Sumter, and bed and breakfast rentals Sumter.
Using this website, FRBO.com, third party listing companies register lodge, condominium, apartment, and houseboat ad directories.
Catch, identify, and observe rental home in Gulf Florida, Gulf Florida vacation homes for rent by owner, and Gulf vacation homes for rent by owner.
Come upon and locate Greenville United States for rent by owner homes and rental homes Greenville United States.
Determine, locate, and uncover home rentals in Sugarloaf Shores, vacation homes in Sugarloaf Shores, and home rentals Sugarloaf Shores.
Glimpse, come upon, and determine Lanark Village condo rentals, rental properties Lanark Village United States, and Lanark Village short term rentals.
Look up, discover, and identify Miami-Dade Florida real estate rentals, Miami-Dade Florida rental properties, and Miami-Dade Florida real estate rentals.
Identify, originate, and come across Sumter condo rentals and houses for rent Sumter Florida.
Arcadia East results could ballyhoo and run interference your expedition.
Debunk and perceive vacation homes and holiday rentals in Macclenny.
Explorers and transmigrants who are wishing to uncover, find out, and observe or simply identify information can use our online website, FRBO.com.
You can frisk the hillside lists of marked properties, beach classified ads, hidden listings, and suburban classified ads under home rentals Arcadia East Florida and Arcadia East Florida rental homes.
Find out, originate, and find Sebastian condo rentals, homes for rent Sebastian United States, and house rentals Sebastian.
Distinguish and find out Seminole Florida vacation homes for rent by owner, apartments for rent in Seminole, real estate rentals in Seminole, and Seminole Florida vacation rentals.
Espy, locate, and discover vacation rentals in South Bay, vacation rental, and houses for rent in South Bay United States.
Conceive and glimpse Wauchula United States real estate rentals and homes for rent by owner in Wauchula United States.
Recognize and find apartment rentals Lake Alfred United States and short term rentals in Lake Alfred United States.
Arcadia East condo owners, landlords, real estate investors, and third party listing companies list apartments for rent in Arcadia East, Arcadia East Florida apartment rentals, and Arcadia East Florida rental properties.
Send foxy and cute documents regarding rent house Arcadia East and Arcadia East vacation homes found on For Rent By Owner.
Our website, FRBO.com consist ofs patch, turf, block, and territory dossier, occasionally.
Espy and move short term rentals Graceville and for rent by owner homes Graceville.
Conceive and hear house rentals in Bushnell and Bushnell houses for rent.
We procreated, erected, and sired this webpage to be fair, alluring, graceful, and charming.
You can originate and find out Arcadia East apartment rentals, vacation homes in Arcadia East Florida, and house rentals.
|
|
