|
<%@ 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
Apartment rentals in Arcadia West Florida and houses for rent in Arcadia West
Vacation homes in Fruit Cove Florida, Fruit Cove Florida homes for rent by owner, and Fruit Cove rental homes
Howey-in-the-Hills-Okahumpka Florida rental houses, Howey-in-the-Hills-Okahumpka rental apartment, for rent by owner homes in Howey-in-the-Hills-Okahumpka, and rental houses Howey-in-the-Hills-Okahumpka Florida
Howey-in-the-Hills-Okahumpka rental homes and condos for rent in Howey-in-the-Hills-Okahumpka
Rental houses Crystal River Florida, Crystal River Florida apartment rentals, and condo rentals Crystal River Florida
Cape Coral vacation homes for rent by owner, house rentals, condo rentals, and rental houses
Melbourne for rent by owner homes and apartment rentals
Vacation rentals, rental home, and rental homes Zephyrhills
Rental apartment in Gulf Breeze-Harold Florida, rent house in Gulf Breeze-Harold Florida, Gulf Breeze-Harold Florida real estate rentals, and rental properties Gulf Breeze-Harold Florida
Rental homes in Tallahassee South Florida and for rent by owner homes Tallahassee South Florida
New Port Richey rental apartment, short term rentals in New Port Richey, and vacation homes in New Port Richey
South Peninsula Florida holiday rentals, rental apartment, South Peninsula Florida apartments for rent, and rental home South Peninsula Florida
Trenton rental home and vacation rentals Trenton
Groveland-Mascotte Florida rental home, Groveland-Mascotte Florida houses for rent, and Groveland-Mascotte Florida rental apartment
House rentals, homes for rent in Perry North, for rent by owner homes in Perry North Florida, and Perry North Florida vacation homes
Find out, design, and identify Minneola vacation rental, vacation rental in Minneola United States, and Minneola United States condos for rent.
Entrepreneurs and commuters shake down and run down our webpage and explore resort vacation home and log hacienda.
Miami Beach Florida is a resplendent, enticing, excellent, and classy stretch with shapely and angelic vacation home, cabin, timeshare, and cottages.
Notice distinct and another story conclusions in Miami Beach Florida and numerate rental properties in Miami Beach.
Find out, uncover, and find for rent by owner homes Apopka, apartment rentals in Apopka United States, and rental properties.
Find out and originate house rentals Manatee Florida, short term rentals, and short term rentals in Manatee Florida.
Catch, originate, and espy Broward Florida apartment rentals, rental properties Broward Florida, and bed and breakfast rentals Broward.
Determine, light upon, and learn rental properties Hamilton Florida, Hamilton Florida bed and breakfast rentals, and apartments for rent in Hamilton Florida.
Observe, contrive, and discern rent house in Gilchrist and Gilchrist Florida rent house.
Miami Beach Florida picture could work with, facilitate, help, and help your exploration.
Our webpage involves kingdom, territory, and dominion statistics, generally.
Learn, disclose, and dig up vacation rental Bristol United States, rental home in Bristol, and Bristol condo rentals.
Our for rent by owner site, FRBO.com does embrace novel county decadent and well appointed flat and bungalows.
You can chase after the beach online MLS, hillside indexes, beach lists of marked properties, and ski in/out classified advertisements under rental homes Miami Beach Florida and rent house in Miami Beach.
Perceive and light upon short term rentals Collier and vacation homes Collier.
The Miami Beach ad directories tabulated and run down on our website, FRBO.com except romantic farmhouse, beach chalet, log hacienda, and log farmhouse.
Learn and come upon Orange Florida houses for rent, Orange Florida rental houses, rental properties in Orange Florida, and Orange vacation rentals.
Come across and discern Hamilton Florida vacation rental, rental properties Hamilton, Hamilton Florida short term rentals, and home rentals Hamilton.
Invent and notice house rentals in Nichols United States and rental apartment Nichols.
Buddies, adventurers, and students who are wishing to come across, devise, and identify or simply learn information can use our page.
Inaugurate your research online tomorrow morning, day after tomorrow, on Saturday, or on Wednesday for your Miami Beach vacation rentals, rental homes in Miami Beach, and rental apartment Miami Beach Florida.
Disclose and relocate homes for rent in Macclenny United States and Macclenny rental houses.
Locate, contrive, and recognize Sanderson bed and breakfast rentals, vacation rentals in Sanderson United States, and rental properties Sanderson.
The Miami Beach private listings and private ad directories for these can be mapped.
|
|
