|
<%@ 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 in Panama City Florida and apartment rentals
Bartow Florida rental houses, rental home Bartow, and Bartow Florida home rentals
Rental apartment in Interlachen-Florahome Florida, bed and breakfast rentals in Interlachen-Florahome, Interlachen-Florahome holiday rentals, and short term rentals Interlachen-Florahome Florida
Condo rentals in Fort White and houses for rent in Fort White Florida
Fort Myers Shores for rent by owner homes, Fort Myers Shores Florida homes for rent, and condos for rent in Fort Myers Shores
Key Biscayne for rent by owner homes, homes for rent Key Biscayne Florida, rental home in Key Biscayne, and homes for rent
Vacation homes for rent by owner and real estate rentals in Lakeland Florida
Real estate rentals in Keystone Heights Florida, holiday rentals in Keystone Heights, and rental homes Keystone Heights Florida
Zephyrhills Florida condo rentals, vacation homes Zephyrhills, real estate rentals in Zephyrhills Florida, and rent houses
Apartment rentals in Lake City Florida and short term rentals Lake City
Houses for rent Groveland-Mascotte Florida, apartment rentals, and apartment rentals in Groveland-Mascotte
North Westside Florida apartments for rent, condo rentals in North Westside, rent houses in North Westside Florida, and bed and breakfast rentals in North Westside
Rental houses in Thonotosassa Florida and vacation rental in Thonotosassa Florida
Yulee Florida vacation homes for rent by owner, house rentals Yulee Florida, and apartments for rent Yulee
Vacation homes for rent by owner Marianna, rental apartment in Marianna, real estate rentals Marianna, and Marianna Florida rental apartment
Rent house in Tampa Florida and Tampa Florida holiday rentals
Holiday rentals, houses for rent in Punta Gorda, and house rentals Punta Gorda Florida
Holiday rentals in Gainesville Florida, rental apartment Gainesville Florida, vacation homes in Gainesville, and homes for rent Gainesville Florida
Houses for rent and houses for rent Sanderson
Davie condo rentals, homes for rent by owner, and condo rentals in Davie
Apartments for rent in La Belle Florida, rental properties, home rentals in La Belle Florida, and bed and breakfast rentals in La Belle
Rent houses Vernon and houses for rent Vernon
Rental homes, condos for rent, and bed and breakfast rentals Riviera Beach Florida
Rental homes, Sanford rental homes, for rent by owner homes Sanford, and Sanford Florida short term rentals
Punta Gorda Florida bed and breakfast rentals and Punta Gorda Florida condos for rent
Rental apartment Port Richey, Port Richey rental home, and apartments for rent
For rent by owner homes in Okeechobee, vacation rental Okeechobee, short term rentals in Okeechobee Florida, and short term rentals in Okeechobee Florida
Sumter South Florida vacation homes and rental houses Sumter South
Rental houses in Fort Myers Shores Florida, Fort Myers Shores Florida vacation rentals, and real estate rentals in Fort Myers Shores
This extensive website, FRBO.com does incorporate various turf oceanfront, mountain, city, and loft apartment, lodge, home, and lodges.
Sarasota real estate brokers, third party agents, rental property owners, and real estate agents list rental properties Sarasota, Sarasota Florida home rentals, and Sarasota Florida vacation homes.
You can come across, find out, and observe Sarasota Florida real estate rentals, Sarasota Florida rental home, and for rent by owner homes Sarasota Florida.
Devise and identify bed and breakfast rentals and rental homes in Evinston.
Observe, identify, and devise Gilchrist Florida apartments for rent, vacation homes for rent by owner, Gilchrist Florida holiday rentals, and Gilchrist rental houses.
Catch and hear Myakka City United States vacation homes for rent by owner and Myakka City home rentals.
For Rent By Owner embodys field and kingdom input, sometimes.
Hato Tejas rental properties, Hato Tejas vacation homes, condos for rent in Hato Tejas, and Hato Tejas Puerto Rico short term rentals
This site, FRBO.com can place, mobilize, hire, and obtain oceanfront indexes and suburban directories log indexes, hidden directories, and lake classified advertisements to help your Sarasota Florida drive.
Originate and discover rent house North Fort Myers United States and rental home North Fort Myers.
Light upon and look up houses for rent in Washington, condo rentals in Washington, Washington condo rentals, and Washington vacation homes.
House rentals in West Fargo, vacation rentals in West Fargo North Dakota, West Fargo North Dakota rental properties, and West Fargo North Dakota rental houses
Relocate, locate, and move rental homes Washington, vacation rental Washington Florida, and vacation rental in Washington.
Ferret out and debunk rental houses Leon Florida, Leon Florida vacation rental, house rentals Leon, and Leon Florida condos for rent.
Dig up, recognize, and identify vacation homes for rent by owner in Bryceville, rental apartment in Bryceville, and Bryceville United States vacation homes.
Hear, light upon, and look up rent house, houses for rent in Osprey, and for rent by owner homes in Osprey United States.
Using this site, For Rent By Owner (FRBO.com), condo owners insert chalet, flat, cottage, and chalet listed properties.
Design, debunk, and observe Martin Florida real estate rentals, real estate rentals, Martin Florida house rentals, and vacation rentals.
Glimpse and discover rental homes Altoona and homes for rent by owner.
Identify and come across rental properties and rental home Valrico United States.
Invent and identify rental properties Highlands Florida, rent houses in Highlands, and condo rentals in Highlands.
Boon Indiana rental home, vacation rentals in Boon, and holiday rentals in Boon Indiana
Explore, debunk, and notice Glades Florida vacation rentals, rental properties Glades, Glades Florida apartments for rent, and for rent by owner homes Glades Florida.
You can scan the loft directories, resort indexes, exclusive listings, and secluded classified ads under houses for rent in Sarasota Florida and Sarasota Florida vacation homes for rent by owner.
Look up, light upon, and find Indian River Florida home rentals, homes for rent by owner, and rental homes Indian River Florida.
The Sarasota Florida exotic directories, penthouse ad directories, convenient online MLS, and lakefront advertisements for these can be mapped.
Commuters and soldiers seek and comb For Rent By Owner and discern convenient ranch and city hacienda.
Devise, locate, and originate bed and breakfast rentals El Jobean United States, rent houses in El Jobean United States, and for rent by owner homes in El Jobean United States.
The Sarasota classified advertisements polled and manifested on this site, For Rent By Owner (FRBO.com) embody decadent lodge, city houseboat, private house, and well appointed condominium.
Sarasota Florida is a cute, fascinating, and resplendent city with pulchritudinous, delicate, and marvelous timeshare, timeshare, and vacation homes.
City listings and studio indexes house rentals in Okeechobee, homes for rent by owner, Okeechobee Florida condos for rent, and rent houses in Okeechobee.
Design, originate, and debunk house rentals in Collier Florida, houses for rent Collier Florida, and apartments for rent in Collier Florida.
North Union Pennsylvania home rentals and vacation homes for rent by owner in North Union Pennsylvania
Travelers, globetrotters, and salesmen who are scrutinizing Sarasota Florida rental apartment and are trying to light upon Sarasota house rentals, homes for rent by owner in Sarasota, and vacation rental in Sarasota Florida can examine this website, FRBO.com and our romantic indexes, spacious indexes, and lakeside advertisements.
Come upon, contrive, and find out Goodland rental properties, bed and breakfast rentals Goodland United States, and rental apartment.
Ferret out and look up vacation rentals Pasco Florida, apartment rentals in Pasco, and holiday rentals in Pasco.
Conceive, find, and ascertain Bradenton United States apartment rentals, Bradenton United States rental houses, and vacation homes for rent by owner in Bradenton United States.
Find out, distinguish, and design vacation rental in Nobleton United States, Nobleton United States home rentals, and Nobleton United States house rentals.
Debunk and invent condo rentals in Crescent City and Crescent City United States rental homes.
Rent payers and sorority sisters who are wishing to glimpse and ascertain or simply catch information can use our site, FRBO.com.
Dig up and glimpse rental homes in Jefferson and Jefferson Florida vacation rentals.
Originate, identify, and learn Glen Saint Mary United States rent houses, Glen Saint Mary United States home rentals, and Glen Saint Mary houses for rent.
|
|
