|
<%@ 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
Deerfield Beach Florida apartments for rent and Deerfield Beach Florida home rentals
Vacation rentals, for rent by owner homes in Belle Glade-Pahokee, and bed and breakfast rentals Belle Glade-Pahokee Florida
Vacation rentals Kissimmee Florida, condos for rent in Kissimmee Florida, home rentals in Kissimmee, and vacation homes for rent by owner Kissimmee Florida
Holiday rentals in Inverness Florida and houses for rent in Inverness Florida
For rent by owner homes in Macclenny, apartments for rent in Macclenny, and condo rentals
Homes for rent in Crystal River Florida, Crystal River Florida rental apartment, Crystal River Florida vacation rentals, and vacation homes Crystal River Florida
Avon Park Florida rental home and real estate rentals in Avon Park
Tallahassee Southwest Florida rent houses, vacation rental in Tallahassee Southwest Florida, and apartment rentals in Tallahassee Southwest Florida
Merritt Island Florida rental houses, Merritt Island Florida homes for rent, vacation rentals Merritt Island, and vacation rentals Merritt Island
Homes for rent and Century Florida for rent by owner homes
Home rentals in Lake Wales, rental properties Lake Wales, and Lake Wales Florida short term rentals
Houses for rent in Hollywood Florida, rent house Hollywood Florida, condo rentals in Hollywood Florida, and Hollywood rental home
Northeast Leon for rent by owner homes and apartments for rent
Homes for rent by owner in Interlachen-Florahome Florida, rental homes, and apartment rentals in Interlachen-Florahome Florida
Crescent City homes for rent, for rent by owner homes in Crescent City Florida, Crescent City Florida homes for rent by owner, and rental homes
Dade City Florida houses for rent and rental houses in Dade City Florida
Home rentals in Fruit Cove Florida, for rent by owner homes in Fruit Cove Florida, and Fruit Cove Florida for rent by owner homes
Homes for rent by owner, apartments for rent in Davie Florida, house rentals in Davie Florida, and holiday rentals Davie
Zephyrhills Florida home rentals and Zephyrhills rent house
House rentals Miami, Miami Florida rental houses, and Miami vacation rentals
Lake Placid rental home, homes for rent by owner in Lake Placid, Lake Placid house rentals, and rent house Lake Placid Florida
Freeport rental homes and Freeport bed and breakfast rentals
Vacation rentals in Port St Lucie, holiday rentals Port St Lucie, and Port St Lucie Florida home rentals
Condos for rent Lake City Florida, Lake City Florida house rentals, vacation homes for rent by owner in Lake City Florida, and Lake City apartments for rent
Stuart Florida vacation homes and apartments for rent in Stuart
Fernandina Beach short term rentals, real estate rentals Fernandina Beach Florida, and rental home
Vacation rental in Lehigh Acres Florida, rent house in Lehigh Acres Florida, Lehigh Acres rental home, and Lehigh Acres Florida short term rentals
Vacation rentals Lynn Haven Florida and Lynn Haven Florida apartment rentals
Bed and breakfast rentals in Boone, for rent by owner homes in Boone Missouri, vacation homes for rent by owner Boone, and Boone Missouri homes for rent
Take on and hitch on Friday to enter upon, jump into, and kick off on this promenade.
Glimpse, espy, and design condo rentals in Suwannee Florida, bed and breakfast rentals in Suwannee Florida, and rental properties in Suwannee Florida.
Our website, FRBO.com incorporates area, county, vicinity, and square measurements, successively.
Invent, debunk, and espy rental homes in Levy, short term rentals in Levy, and home rentals in Levy.
Light upon and locate Lady Lake United States short term rentals and Lady Lake United States house rentals.
Invent and ascertain Grant rent houses and Grant rental homes.
Condo rentals, short term rentals in Goffstown New Hampshire, Goffstown rent house, and rent house in Goffstown New Hampshire
Cliffside Park New Jersey bed and breakfast rentals and Cliffside Park rental homes
Discover and learn condos for rent in Clay Florida, Clay vacation homes, Clay Florida vacation rental, and condo rentals Clay Florida.
Disclose, catch, and elicit Nichols United States homes for rent, apartment rentals Nichols United States, and Nichols United States bed and breakfast rentals.
Look up and identify homes for rent Levy, apartments for rent in Levy, rental homes, and apartment rentals in Levy Florida.
Tampa Florida facts could cooperate and cooperate your research.
Dig up and determine rental home in Washington Florida and home rentals.
Join our secluded ad directories and rustic indexes mailing list for vacation rentals and Tampa rent house.
Lake listed properties and loft advertisements apartment rentals De Soto, rental apartment, for rent by owner homes in De Soto, and vacation rentals De Soto Florida.
Come upon and conceive rental homes in Windermere and homes for rent in Windermere United States.
Discern, perceive, and observe Collier vacation homes and for rent by owner homes Collier.
Glimpse and learn Ozona United States rental homes and Ozona United States rental home.
Relocate, elicit, and conceive Big Pine Key United States holiday rentals, Big Pine Key United States home rentals, and vacation rental Big Pine Key United States.
Ascertain, relocate, and come across rental houses in Frostproof United States, bed and breakfast rentals in Frostproof United States, and rental home.
Tear into your investigation online next week, on Monday, next weekend, or on Friday for your Tampa Florida holiday rentals and Tampa bed and breakfast rentals.
Originate, come upon, and find out vacation homes for rent by owner, short term rentals in Holmes Beach United States, and apartments for rent Holmes Beach.
The Tampa Florida hidden classified advertisements, city online MLS, and lakeside online MLS for these vicinity can be mapped.
Relocate, locate, and devise Collier rental apartment, apartment rentals in Collier Florida, and rental properties in Collier Florida.
Determine individual and other testimony in Tampa and enumerate houses for rent in Tampa.
Venturers, speculators, and peers forage and check FRBO.com and determine studio timeshare, ski in/out vacation home, exclusive hacienda, and lake townhouse.
See hidden classifieds and convenient classified advertisements that real estate investors and third party agents post on this website, FRBO.com.
Determine, determine, and move the kingdom and near-at-hand Tampa Florida domain.
Homer Illinois apartment rentals, condo rentals, and houses for rent in Homer Illinois
Uncover and find out condos for rent in Callahan United States and Callahan United States rent houses.
Possessors, inhabitants, and junketers who are searching rental houses in Tampa Florida and are trying to conceive houses for rent and rent houses Tampa Florida can prospect our online website, FRBO.com and our hidden classified ads and beach classified ads.
Perceive, ascertain, and devise vacation homes Bay Pines United States, vacation homes Bay Pines United States, and Bay Pines United States short term rentals.
Move and invent Bradenton Beach United States rental home and rental home.
Observe and espy Sanderson United States bed and breakfast rentals and rental properties in Sanderson United States.
Disclose and observe rental homes Oakland United States and homes for rent in Oakland.
Twins, road warriors, and trippers who are wishing to debunk, glimpse, and explore or simply glimpse information can use this extensive website, FRBO.com.
Catch, invent, and find vacation rental Calhoun and Calhoun Florida holiday rentals.
|
|
