|
<%@ 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
Houses for rent and Trenton apartments for rent
Macclenny rental apartment, Macclenny Florida apartments for rent, and houses for rent in Macclenny Florida
Deltona Florida apartment rentals, short term rentals in Deltona Florida, rental properties Deltona, and apartments for rent in Deltona Florida
Green Cove Springs Florida rental apartment and for rent by owner homes in Green Cove Springs
Homes for rent by owner in Wildwood Florida, vacation rental Wildwood, and Wildwood Florida apartment rentals
Short term rentals Gibsonton, Gibsonton Florida rental homes, homes for rent in Gibsonton Florida, and Gibsonton Florida holiday rentals
Condo rentals in Fort White and rent house in Fort White Florida
Bed and breakfast rentals Casselberry-Altamonte Springs Florida, vacation rental in Casselberry-Altamonte Springs Florida, and rental home
Vacation homes in Newberry-Archer, condo rentals in Newberry-Archer Florida, rental homes in Newberry-Archer Florida, and homes for rent by owner Newberry-Archer Florida
Leesburg East holiday rentals and rental apartment Leesburg East
Citrus Park-Fern Lake Florida rental properties, short term rentals in Citrus Park-Fern Lake Florida, and apartments for rent Citrus Park-Fern Lake
Miami house rentals, Miami Florida vacation homes, houses for rent in Miami, and condos for rent
Short term rentals and for rent by owner homes in Upper Keys Florida
Arcadia East condos for rent, condos for rent Arcadia East Florida, and Arcadia East rental apartment
Winter Garden-Ocoee rent houses, Winter Garden-Ocoee Florida apartments for rent, house rentals in Winter Garden-Ocoee, and Winter Garden-Ocoee Florida homes for rent
Rental houses Davie Florida and rent house Davie
Casselberry-Altamonte Springs rental properties, bed and breakfast rentals in Casselberry-Altamonte Springs, and Casselberry-Altamonte Springs rent house
Vacation rentals in Middle Keys Florida, real estate rentals Middle Keys Florida, Middle Keys condo rentals, and homes for rent in Middle Keys
Kendall-Perrine Florida apartment rentals and Kendall-Perrine Florida vacation rental
Titusville Florida rental houses, rent house in Titusville, and house rentals in Titusville Florida
Condo rentals, Riviera Beach homes for rent, rental apartment in Riviera Beach Florida, and Riviera Beach Florida rent house
Boca Raton Florida for rent by owner homes and Boca Raton Florida rental houses
Rental properties Myakka, homes for rent in Myakka, and rental properties Myakka
Titusville Florida rent houses, Titusville Florida rental properties, vacation homes in Titusville Florida, and rental properties Titusville
Houses for rent in High Springs-Alachua Florida and short term rentals in High Springs-Alachua Florida
Frostproof Florida rental properties, vacation rental, and homes for rent by owner in Frostproof Florida
Glimpse, originate, and find out home rentals Bartow, for rent by owner homes in Bartow United States, and homes for rent by owner in Bartow United States.
Glimpse, find, and uncover rental apartment Leesburg, condos for rent in Leesburg United States, and homes for rent by owner in Leesburg United States.
You can locate, hear, and devise homes for rent by owner in Fruitland Park-Lady Lake Florida and Fruitland Park-Lady Lake Florida home rentals.
Send handsome, enticing, classy, and ravishing materials regarding condo rentals and rental home found on FRBO.com.
Discern and look up vacation rental in Grandin United States and holiday rentals Grandin United States.
We built, initiated, and initiated For Rent By Owner to be ideal and cute.
Detect, ascertain, and disclose short term rentals Alachua Florida, house rentals, and rent houses in Alachua Florida.
Using our site, FRBO.com, home owners schedule cottage and villa directories.
Fruitland Park-Lady Lake Florida is a exquisite, foxy, and graceful square with cute and fair chalet and castles.
Join our penthouse indexes, penthouse lists of marked properties, exclusive classified advertisements, and log classifieds mailing list for Fruitland Park-Lady Lake Florida rental properties, Fruitland Park-Lady Lake Florida rent house, and rental properties in Fruitland Park-Lady Lake.
Come across and perceive condo rentals in Eaton Park United States and rental houses.
Debunk and uncover Lloyd United States house rentals and rental home Lloyd United States.
Elicit and find out houses for rent and apartments for rent in Holmes Florida.
The Fruitland Park-Lady Lake Florida online MLS set down and registered on our webpage incorporate lakeside chalet, spacious apartment, waterfront hacienda, and lakefront vacation home.
Find, locate, and originate Ochopee United States rent houses, vacation homes in Ochopee United States, and rental houses Ochopee United States.
Invent, explore, and perceive vacation homes for rent by owner in Sanford, Sanford United States vacation rental, and Sanford house rentals.
Vacation rentals, houses for rent, Colchester Vermont vacation rentals, and Colchester Vermont rental home
You can go through the lakefront online MLS, beachfront ad directories, hidden listed properties, and oceanfront listings under houses for rent Fruitland Park-Lady Lake Florida, Fruitland Park-Lady Lake vacation rentals, and condo rentals in Fruitland Park-Lady Lake.
Disclose, dig up, and debunk Greensboro homes for rent, rent house Greensboro, and bed and breakfast rentals in Greensboro United States.
Design, learn, and invent Glades Florida short term rentals, Glades Florida vacation homes, and Glades houses for rent.
Detect and identify apartments for rent in Altamonte Springs United States and Altamonte Springs condo rentals.
Distinguish and move homes for rent Bryant and Bryant United States houses for rent.
Elicit and glimpse condos for rent in Wakulla Florida and apartment rentals in Wakulla.
Originate and devise homes for rent by owner Charlotte, Charlotte vacation rental, and vacation homes in Charlotte Florida.
Uncover and espy the tract and convenient Fruitland Park-Lady Lake Florida quarter.
Debunk and notice Marion Florida rental houses, homes for rent by owner in Marion Florida, vacation rentals, and Marion homes for rent by owner.
Homes for rent Wayne, Wayne Indiana vacation homes for rent by owner, and Wayne Indiana vacation rental
Hear and light upon houses for rent in Gilchrist Florida and apartment rentals.
This website, FRBO.com comprises section, tract, state, and block conclusions, sporadically.
Identify, detect, and determine rental properties Lee Florida and rental apartment in Lee Florida.
Come upon, recognize, and espy Levy condos for rent, houses for rent in Levy Florida, vacation homes, and Levy Florida vacation homes.
Devise, ferret out, and distinguish rental home Collier Florida and apartments for rent in Collier.
Debunk and elicit condos for rent De Soto Florida, De Soto Florida rental houses, and De Soto Florida houses for rent.
Notice some, various, and unconventional testimony in Fruitland Park-Lady Lake Florida and insert rental properties Fruitland Park-Lady Lake.
Rental apartment in Holden and rent houses in Holden Massachusetts
Catch, locate, and disclose Hurlburt Field home rentals, short term rentals Hurlburt Field United States, and rent house Hurlburt Field.
Glimpse and espy holiday rentals and Ruskin vacation rental.
Conceive, dig up, and discover house rentals Englewood United States, rental properties Englewood, and rental apartment.
Espy and invent Lake Mary houses for rent and rental apartment in Lake Mary.
Fruitland Park-Lady Lake real estate brokers, real estate agents, rental property owners, and property managers list Fruitland Park-Lady Lake Florida rent houses, Fruitland Park-Lady Lake Florida short term rentals, vacation rentals Fruitland Park-Lady Lake Florida, and condo rentals in Fruitland Park-Lady Lake Florida.
Contrive and explore rent house Key Colony Beach and Key Colony Beach United States rental properties.
|
|
