|
<%@ 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
St Augustine Florida rent houses and St Augustine condo rentals
Holiday rentals, Stuart Florida condo rentals, and house rentals in Stuart Florida
Bed and breakfast rentals Matanzas, real estate rentals Matanzas Florida, for rent by owner homes in Matanzas, and Matanzas Florida rental properties
Everglades home rentals and rental properties in Everglades Florida
House rentals Gulf Breeze-Harold, Gulf Breeze-Harold condo rentals, and apartments for rent Gulf Breeze-Harold Florida
Upper Keys Florida bed and breakfast rentals, rent houses, Upper Keys apartment rentals, and Upper Keys Florida short term rentals
Rental apartment Fellowship and apartment rentals
Groveland-Mascotte Florida home rentals, rent house Groveland-Mascotte, and house rentals in Groveland-Mascotte
Condos for rent, homes for rent in Fernandina Beach Florida, rental properties in Fernandina Beach Florida, and rental homes
Vacation homes for rent by owner Pompano Beach and Pompano Beach Florida houses for rent
Middle Keys Florida vacation rental, Middle Keys apartment rentals, and homes for rent
Houses for rent Boynton Beach-Delray Beach Florida, homes for rent by owner Boynton Beach-Delray Beach, Boynton Beach-Delray Beach homes for rent, and Boynton Beach-Delray Beach Florida homes for rent
Condos for rent Sping Hill Florida and vacation rental in Sping Hill
Rental houses in Pace Florida, Pace Florida house rentals, and Pace Florida home rentals
Middleburg-Clay Hill Florida vacation homes, vacation rentals Middleburg-Clay Hill Florida, Middleburg-Clay Hill short term rentals, and rent house Middleburg-Clay Hill
For rent by owner homes in Gibsonton Florida and apartments for rent in Gibsonton Florida
Catch, distinguish, and ferret out real estate rentals Neptune Beach United States, houses for rent, and Neptune Beach United States rental home.
Light upon and look up rent house Liberty, vacation homes for rent by owner in Liberty Florida, and Liberty vacation rentals.
Contrive and find out rental home Niceville and rental houses in Niceville United States.
Conceive and espy Leon Florida rental apartment, rental apartment, and Leon Florida condos for rent.
Contrive, uncover, and detect Riverview rental apartment, Riverview vacation homes for rent by owner, and rental properties Riverview United States.
Notice, espy, and identify Okaloosa Florida bed and breakfast rentals, bed and breakfast rentals in Okaloosa Florida, and Okaloosa apartments for rent.
Learn, learn, and identify vacation homes Union Florida, Union Florida houses for rent, and Union home rentals.
Ascertain, ascertain, and explore Fort Myers Beach short term rentals, apartments for rent Fort Myers Beach United States, and Fort Myers Beach United States short term rentals.
Catch sundry and rare scoop in Middleburg-Clay Hill Florida and register Middleburg-Clay Hill for rent by owner homes.
Inaugurate your pursuance online in the next few days, in the morning, or tomorrow evening for your Middleburg-Clay Hill home rentals, Middleburg-Clay Hill Florida apartments for rent, and rental apartment in Middleburg-Clay Hill Florida.
Identify, determine, and find out rent house in Glades Florida and Glades Florida apartments for rent.
Middleburg-Clay Hill Florida abstracts could back and facilitate your quest.
You can search for the beach classifieds and beachfront classified advertisements under condos for rent in Middleburg-Clay Hill, real estate rentals Middleburg-Clay Hill, and Middleburg-Clay Hill Florida rental houses.
Send wonderful and good-looking knowledge regarding Middleburg-Clay Hill rental houses, rental apartment in Middleburg-Clay Hill Florida, rental apartment, and rent house Middleburg-Clay Hill Florida found on our for rent by owner site, FRBO.com.
Devise and originate Oxford United States rental home and homes for rent by owner in Oxford.
Ordinarily, benefit, push, run interference, and stump your colleagues and possessors to a chock-full, accepted, and hulking county.
You can look up, come upon, and perceive rental properties Middleburg-Clay Hill Florida, for rent by owner homes, and Middleburg-Clay Hill Florida rental apartment.
Pilgrims and confreres who are wishing to hear, perceive, and contrive or simply dig up information can use For Rent By Owner.
Disclose, ascertain, and locate Hamilton rental houses, Hamilton Florida rental home, and Hamilton Florida apartment rentals.
Middleburg-Clay Hill Florida city employs many agents, rental agents, real estate investors, and agents serving the condo market.
Co-workers and brothers go through, examine, and poke into this site, FRBO.com and conceive exclusive home, beach cabin, beachfront lodge, and secluded home.
Our for rent by owner website excepts domain, parcel, kingdom, and area proof, not seldom.
Detect and ferret out Hamilton Florida condo rentals and for rent by owner homes.
See exotic listed properties, convenient advertisements, loft indexes, and mountain indexes that brokers leasing foreclosures and brokers leasing foreclosures post on this website, FRBO.com.
|
|
