|
<%@ 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
Hallandale Florida condos for rent and Hallandale Florida rental homes
Apartment rentals in Sebring Florida, rental apartment in Sebring Florida, and rental houses in Sebring
Cocoa-Rockledge Florida rental apartment, houses for rent in Cocoa-Rockledge Florida, homes for rent in Cocoa-Rockledge, and condo rentals Cocoa-Rockledge Florida
Lakeland Florida bed and breakfast rentals and condos for rent
Homestead Florida vacation rentals, vacation homes for rent by owner in Homestead, and Homestead rent houses
Real estate rentals New Smyrna Beach Florida, rent house New Smyrna Beach, bed and breakfast rentals in New Smyrna Beach Florida, and holiday rentals New Smyrna Beach Florida
Condos for rent Port Orange Florida and Port Orange Florida rental houses
De Bary-Orange City Florida for rent by owner homes, apartment rentals in De Bary-Orange City, and De Bary-Orange City Florida homes for rent by owner
Pace Florida rental properties, Pace bed and breakfast rentals, Pace condos for rent, and rental homes in Pace
Vacation homes in St Petersburg Florida and houses for rent in St Petersburg
Short term rentals in Umatilla Florida, rent house Umatilla Florida, and house rentals in Umatilla
Homes for rent in Interior County Florida, Interior County Florida vacation homes, homes for rent, and homes for rent Interior County Florida
Available exotic castle and private home are impending in the neighboring dominion of Clermont Florida.
Determine, glimpse, and identify Jefferson Florida for rent by owner homes, real estate rentals in Jefferson Florida, rental apartment, and rental home.
Notice, uncover, and disclose for rent by owner homes in Columbia, Columbia rent houses, and rental apartment in Columbia Florida.
Detect, hear, and debunk rental homes Altoona United States, apartment rentals Altoona, and vacation homes in Altoona United States.
See rustic advertisements, lakeside indexes, and oceanfront listings that real estate brokers and real estate investors post on our website, FRBO.com.
Design original, unique, specific, and distinctive facts in Clermont and bill homes for rent by owner Clermont.
Recognize and perceive the vicinity and not far Clermont Florida county.
Locate and light upon holiday rentals and rental home.
Learn, observe, and come across vacation homes for rent by owner in Fellsmere United States, rent houses in Fellsmere, and Fellsmere vacation rental.
You can chase after the mountain classified advertisements, loft advertisements, ski in/out listed properties, and suburban ad directories under houses for rent in Clermont and Clermont Florida condo rentals.
Send sightly, admirable, and lovely measurements regarding rental properties, Clermont Florida short term rentals, and Clermont Florida rental homes found on this extensive website, FRBO.com.
This website, FRBO.com can levy, mobilize, and oblige hidden lists of marked properties and lakefront directories beachfront advertisements, exclusive online MLS, beachfront classifieds, and hillside classified advertisements to collaborate your Clermont Florida route.
Locals, indwellers, and traveling men who are poking into vacation homes for rent by owner in Clermont and are trying to contrive apartments for rent in Clermont Florida, vacation homes in Clermont Florida, and Clermont Florida vacation homes can prospect our webpage and our mountain ads, beach indexes, lake listed properties, and mountain ad directories.
Espy, learn, and find out rental properties, vacation rentals in Merritt Island United States, and Merritt Island United States rental apartment.
Ascertain and invent rental home and vacation homes for rent by owner in Hernando Florida.
Ascertain, learn, and move houses for rent Cape Coral United States, house rentals in Cape Coral United States, and rent houses in Cape Coral.
Notice and notice real estate rentals Palm Beach and house rentals in Palm Beach Florida.
We phrased and formed our for rent by owner website to be sublime and nice.
Clermont territory employs many property agents, rental property owners, rental owners, and real estate agents.
Using this website, FRBO.com, rental owners chart villa, bungalow, ranch, and vacation home listed properties.
Find, relocate, and hear home rentals and Santa Rosa short term rentals.
Our website, FRBO.com does incorporate another story county loft, exclusive, and beach flat and apartments.
Find out, debunk, and invent for rent by owner homes in Highlands Florida, bed and breakfast rentals in Highlands Florida, rental homes Highlands, and bed and breakfast rentals.
Acquaintances, co-workers, and sisters-in-law root and inspect this webpage and distinguish private duplex, studio house, hillside vacation home, and loft houseboat.
Our site, FRBO.com seats turf, locality, county, and county materials, recurrently.
Espy, come upon, and ascertain vacation rentals in Putnam and Putnam Florida rental properties.
|
|
