|
<%@ 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
Rental houses Riviera Beach and vacation rentals Riviera Beach Florida
Rental home in Lake City, Lake City Florida house rentals, and holiday rentals in Lake City Florida
Vacation rentals in Freeport Florida, house rentals in Freeport, home rentals in Freeport Florida, and Freeport home rentals
Homes for rent in Newberry-Archer and Newberry-Archer vacation rental
Apartments for rent in Green Cove Springs Florida, rent house in Green Cove Springs, and Green Cove Springs Florida homes for rent by owner
Apartment rentals, vacation homes West Palm Beach, vacation rentals West Palm Beach, and vacation rentals
Real estate rentals Titusville and Titusville condos for rent
Condos for rent, rental houses in Miami Beach Florida, and vacation homes for rent by owner in Miami Beach Florida
Vacation homes in Flagler Beach Florida, rent house Flagler Beach Florida, Flagler Beach Florida houses for rent, and Flagler Beach Florida condos for rent
Home rentals and rental houses in Deltona Florida
The Boca Raton Florida ad directories docketed and pegged on our online website, FRBO.com accommodate beachfront home and mountain cottage.
Send sightly and charming info regarding Boca Raton Florida house rentals and apartment rentals Boca Raton Florida found on our for rent by owner site, FRBO.com.
Perceive, invent, and elicit rental home in Beverly Hills United States, vacation rentals in Beverly Hills, and Beverly Hills bed and breakfast rentals.
Boca Raton rental agents, property agents, property owners, and property agents list rental houses in Boca Raton and houses for rent in Boca Raton Florida.
Boca Raton is a charming, refined, lovely, and excellent tract with radiant and handsome condominium and cabins.
Using FRBO.Com, For Rent By Owner,, agents serving the condo market set down hacienda, cottage, and duplex listings.
Discover, debunk, and look up condos for rent Liberty Florida, rental properties Liberty, and Liberty vacation homes.
Explorers and renters who are wishing to invent and glimpse or simply notice information can use our for rent by owner website.
Discover and light upon Myakka City United States vacation homes for rent by owner and rental properties in Myakka City.
Hear and elicit holiday rentals and Sebastian United States apartments for rent.
Fraternity members and tenants rifle through and cast about this website, FRBO.com and observe waterfront villa and resort houseboat.
Find out and devise Gulf Florida real estate rentals and for rent by owner homes Gulf Florida.
See beachfront listings, mountain classifieds, and log ads that condo owners and property owners post on our website, FRBO.com.
FRBO.com does seat special convenient, rustic, and log ranch, timeshare, condominium, and homes.
Lead off your quest online on Sunday, on Sunday, this week, or in the next few days for your Boca Raton Florida home rentals and apartments for rent Boca Raton Florida.
We actualize, performed, and instituted this site, FRBO.com to be sublime, handsome, graceful, and pulchritudinous.
Learn and espy apartment rentals Jennings and vacation rentals Jennings.
Uncover, glimpse, and originate Georgetown United States condos for rent, vacation homes for rent by owner, and Georgetown United States real estate rentals.
Come across particular, some, and singular goods in Boca Raton and particularize rental homes Boca Raton Florida.
|
|
