|
<%@ 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
Real estate rentals in Fruitland Park-Lady Lake Florida and condos for rent in Fruitland Park-Lady Lake
Houses for rent in Palatka Florida, real estate rentals in Palatka Florida, and vacation rentals Palatka Florida
Clewiston Florida real estate rentals, vacation rental, Clewiston Florida vacation homes, and rent house in Clewiston Florida
Rent houses in Tallahassee East Florida and vacation rental in Tallahassee East Florida
Sebring Florida rental apartment, rental homes, and Sebring Florida vacation homes for rent by owner
Rental homes in Merritt Island Florida, Merritt Island Florida for rent by owner homes, homes for rent Merritt Island, and vacation rental
Rental properties De Funiak Springs Florida and condo rentals in De Funiak Springs Florida
Houses for rent in Venice, bed and breakfast rentals in Venice Florida, and vacation rentals
Northwest Leon Florida houses for rent, Northwest Leon vacation homes, bed and breakfast rentals, and condos for rent Northwest Leon Florida
House rentals in Pensacola Florida and vacation homes in Pensacola
Vacation rentals in Lake Worth Florida, houses for rent, and rent house Lake Worth Florida
Vacation homes for rent by owner in Groveland-Mascotte, holiday rentals Groveland-Mascotte, rental properties Groveland-Mascotte Florida, and Groveland-Mascotte Florida rental home
Rental apartment in Indialantic-Melbourne Beach Florida and condo rentals in Indialantic-Melbourne Beach Florida
Holiday rentals Naples Florida, vacation rentals Naples Florida, and apartments for rent in Naples
Rent house in Bonita Springs Florida, houses for rent in Bonita Springs, apartments for rent, and Bonita Springs Florida rental home
Avon Park Florida holiday rentals and rent houses Avon Park
La Belle Florida bed and breakfast rentals, real estate rentals in La Belle Florida, and La Belle Florida rental properties
House rentals Brandon, rental apartment in Brandon Florida, rental properties in Brandon, and rent house
Boca Ciega vacation homes and holiday rentals in Boca Ciega Florida
Vacation homes in De Land Florida, rent house in De Land, and rental houses in De Land Florida
Palmetto Florida vacation rentals, rent house in Palmetto Florida, Palmetto Florida homes for rent, and short term rentals in Palmetto Florida
Short term rentals Royal Palm Beach-West Jupiter Florida and short term rentals Royal Palm Beach-West Jupiter
Apartment rentals, home rentals in Sarasota Florida, and rental properties Sarasota
Houses for rent, Indiantown houses for rent, Indiantown homes for rent by owner, and Indiantown Florida condos for rent
Bed and breakfast rentals Chiefland Florida and rent house Chiefland
Vacation rental in Madison, rental properties in Madison, and Madison vacation homes
Quincy for rent by owner homes, Quincy vacation rental, bed and breakfast rentals in Quincy Florida, and rent houses in Quincy
Zephyrhills rental homes and short term rentals in Zephyrhills
Newberry-Archer Florida house rentals, homes for rent in Newberry-Archer Florida, and rental apartment
Houses for rent Vernon Florida, rental homes in Vernon Florida, Vernon Florida holiday rentals, and homes for rent
Rental properties in Miami Florida and Miami Florida holiday rentals
Dig up and observe home rentals in Bradford, home rentals in Bradford Florida, vacation rentals in Bradford Florida, and Bradford Florida bed and breakfast rentals.
We conceived and fashioned our website, FRBO.com to be admirable, pleasing, taking, and well-formed.
Design and espy vacation rental Old Town and homes for rent Old Town.
Holiday rentals in Longmont Colorado and apartment rentals in Longmont Colorado
Perceive and devise condos for rent Haines City United States and Haines City home rentals.
The Titusville Florida listings registered and written down on For Rent By Owner embrace ski in/out timeshare and city cottage.
Vacation rental in Willingboro New Jersey and Willingboro New Jersey home rentals
Williamsburg real estate rentals, Williamsburg Virginia homes for rent, houses for rent, and Williamsburg Virginia home rentals
Find and come across rental home Lawtey United States and Lawtey United States apartment rentals.
Recognize and learn vacation homes for rent by owner in Orange Lake United States and Orange Lake United States condo rentals.
Catch, recognize, and hear apartment rentals in Largo United States, short term rentals in Largo United States, and Largo rental properties.
Identify, ascertain, and determine Bronson United States rental properties, Bronson United States homes for rent by owner, and vacation rental Bronson.
Debunk and detect Greensboro United States short term rentals and rent houses.
Hear, design, and discover Grant United States vacation rental, Grant vacation homes for rent by owner, and Grant apartment rentals.
Recognize, debunk, and find out rental homes in Gulf Hammock United States, Gulf Hammock United States vacation homes for rent by owner, and rent houses Gulf Hammock United States.
Send wonderful, pleasing, and taking poop sheet regarding Titusville Florida apartments for rent, Titusville Florida rental properties, Titusville Florida vacation homes, and apartments for rent in Titusville found on our online website, FRBO.com.
Disclose and detect rental homes in Clarcona United States and rental houses.
Recognize, debunk, and find holiday rentals in Levy Florida, home rentals, and Levy Florida for rent by owner homes.
Move, identify, and find out Volusia Florida vacation rentals, house rentals, and rental apartment Volusia Florida.
Vacation homes Pottsville Pennsylvania, apartment rentals in Pottsville Pennsylvania, Pottsville Pennsylvania for rent by owner homes, and rental apartment
Identify and espy rent houses Dunnellon United States and short term rentals in Dunnellon United States.
Twins, possessors, and inhabitants who are poking into condo rentals Titusville Florida and are trying to determine Titusville Florida vacation rental, holiday rentals in Titusville, and Titusville Florida bed and breakfast rentals can investigate this extensive website, FRBO.com and our spacious classified ads and mountain online MLS.
The Titusville Florida lake ad directories and well appointed classifieds for these neighborhood can be mapped.
Debunk and espy Jefferson homes for rent by owner, rental apartment Jefferson Florida, and Jefferson Florida rental houses.
Titusville land owners, town home owners, condo owners, and property owners list Titusville vacation homes for rent by owner and Titusville Florida real estate rentals.
Devise and glimpse condo rentals in Bonifay United States and Bonifay United States homes for rent.
Condo rentals in Buena Vista charter Michigan, bed and breakfast rentals in Buena Vista charter, houses for rent Buena Vista charter, and houses for rent
Rental properties in Wind River Wyoming and Wind River rental homes
Originate and perceive Astatula United States for rent by owner homes and bed and breakfast rentals.
Identify and come across rental homes and Madison United States vacation homes for rent by owner.
Notice, detect, and uncover Crescent City rental properties, real estate rentals Crescent City, and homes for rent by owner Crescent City.
You can disclose, recognize, and espy rental apartment Titusville and vacation homes Titusville.
Relocate, invent, and uncover Hurlburt Field rental home, Hurlburt Field United States vacation homes, and Hurlburt Field rental home.
Notice and come across for rent by owner homes in Apollo Beach United States and Apollo Beach United States apartments for rent.
Light upon, elicit, and catch Hamilton rental properties, Hamilton Florida condos for rent, Hamilton holiday rentals, and houses for rent.
Open your research online now, on Thursday, next week, or tomorrow afternoon for your Titusville homes for rent by owner, rent house Titusville, and real estate rentals Titusville.
FRBO.com does embrace unusual loft, spacious, mountain, and log lodge and townhouses.
Relocate, explore, and debunk bed and breakfast rentals, vacation homes in Satellite Beach United States, and Satellite Beach rental apartment.
Conceive, recognize, and design condo rentals in Wakulla Springs, rental home in Wakulla Springs, and condo rentals in Wakulla Springs United States.
Dig up and espy rental properties in Miami-Dade Florida, Miami-Dade Florida rental properties, Miami-Dade Florida house rentals, and Miami-Dade for rent by owner homes.
|
|
