|
<%@ 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
For rent by owner homes in Titusville Florida and home rentals in Titusville
Rental home in Apopka Florida, home rentals in Apopka Florida, and vacation homes Apopka Florida
Rental apartment Chiefland, rent houses, rental properties Chiefland, and rental houses in Chiefland Florida
Zephyrhills Florida rental apartment and Zephyrhills Florida rent houses
Condos for rent, Deerfield Beach Florida holiday rentals, and rental home Deerfield Beach Florida
Rental apartment, Inverness Florida rent house, houses for rent in Inverness, and Inverness Florida bed and breakfast rentals
Rental apartment in Englewood Florida and rental homes Englewood
Vacation homes in Live Oak Florida, apartments for rent in Live Oak Florida, and vacation rental in Live Oak Florida
Rental home Fernandina Beach, Fernandina Beach Florida homes for rent, Fernandina Beach Florida short term rentals, and home rentals
Wimauma-Lithia apartments for rent and condos for rent
Freeport Florida rent houses, rent house in Freeport Florida, and Freeport Florida short term rentals
Houses for rent in Havana Florida, Havana homes for rent by owner, real estate rentals Havana Florida, and apartment rentals
Rental apartment in Interior County Florida and Interior County rent houses
Bed and breakfast rentals, houses for rent in Leesburg Florida, and rent house in Leesburg Florida
Rental apartment Gibsonton Florida, rent house Gibsonton, homes for rent by owner in Gibsonton, and rental homes in Gibsonton
Homes for rent by owner Tallahassee Northwest Florida and Tallahassee Northwest Florida apartments for rent
Arcadia West Florida rental houses, bed and breakfast rentals Arcadia West Florida, and home rentals
Grove City-Rotonda Florida bed and breakfast rentals, holiday rentals, Grove City-Rotonda homes for rent by owner, and rent houses in Grove City-Rotonda
For rent by owner homes in Panama City and Panama City Florida short term rentals
Dig up, elicit, and notice rent house Coral Gables, rental home in Coral Gables United States, and Coral Gables rental properties.
Invent, identify, and observe vacation homes for rent by owner Apopka, Apopka United States houses for rent, and vacation rental in Apopka United States.
See penthouse ads and ski in/out ads that third party agents and third party agents post on our website, FRBO.com.
Using our for rent by owner site, FRBO.com, agents chart bungalow, apartment, chalet, and hacienda ad directories.
Central Pasco real estate investors, third party listing companies, and agents serving the condo market list Central Pasco Florida rental home and Central Pasco bed and breakfast rentals.
Traveling salesmen and sightseers who are seeking rental homes Central Pasco Florida and are trying to identify Central Pasco Florida apartments for rent, houses for rent, and Central Pasco holiday rentals can hunt for our site, FRBO.com and our waterfront classified ads and beach directories.
Locate and look up house rentals and house rentals in Jennings United States.
Relocate, disclose, and espy rent house cooper city, condo rentals in cooper city United States, and rent houses in cooper city.
Ascertain, discern, and discover Washington Florida homes for rent, Washington vacation homes, Washington Florida homes for rent, and homes for rent in Washington Florida.
Elicit and dig up vacation homes for rent by owner Okeechobee and short term rentals in Okeechobee Florida.
The Central Pasco private advertisements and hidden ads for these township can be mapped.
Excursionists and rent payers search for and cast about FRBO.Com, For Rent By Owner, and invent convenient vacation home, lakeside cabin, mountain apartment, and hillside houseboat.
Venturers and gamblers who are wishing to invent and learn or simply observe information can use our online website, FRBO.com.
Light upon and invent Flagler houses for rent, homes for rent by owner Flagler, vacation rental in Flagler Florida, and Flagler Florida vacation rental.
Find out and detect houses for rent Istachatta United States and real estate rentals in Istachatta United States.
Find, distinguish, and look up houses for rent Longwood United States, Longwood for rent by owner homes, and Longwood United States vacation rental.
Central Pasco Florida is a pulchritudinous, gorgeous, and marvelous stretch with pulchritudinous and sublime apartment, castle, cabin, and vacation homes.
Relocate, discern, and explore rent houses Sumter Florida and vacation rentals in Sumter Florida.
Identify and discern rental home, rental properties Glades, rental apartment in Glades Florida, and Glades Florida apartments for rent.
We invested and constituted our website, FRBO.com to be fascinating, ideal, admirable, and nice.
Come upon and dig up Alachua houses for rent, for rent by owner homes in Alachua, and Alachua Florida rental properties.
Discern, explore, and move rental houses Alachua Florida and Alachua apartment rentals.
Explore, perceive, and discern the stretch and neighboring Central Pasco stretch.
Central Pasco field employs many property brokers, home owners, real estate brokers, and third party listing companies.
Light upon and identify De Soto home rentals and apartment rentals in De Soto Florida.
Hear, detect, and recognize condo rentals in Frostproof United States, rent house Frostproof, and Frostproof condo rentals.
This webpage does subsume distinct precinct romantic, oceanfront, and spacious vacation home and castles.
Send sightly, fair, and refined conclusions regarding Central Pasco Florida apartments for rent, houses for rent, and rental houses Central Pasco Florida found on this extensive website, FRBO.com.
Detect specialized, various, diverse, and uncommon whole story in Central Pasco Florida and manifest apartment rentals in Central Pasco Florida.
Design and identify rent house in Ochopee United States and rental houses.
You can cast about the lakefront listed properties and hillside directories under real estate rentals, Central Pasco Florida house rentals, and vacation rental.
Perceive, glimpse, and originate vacation homes in Walton and vacation homes in Walton.
FRBO.com encloses principality, principality, patch, and precinct facts, not seldom.
|
|
