|
<%@ 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" %>
|
North Carolina Rental Links
Rental home in Township 6 Clear Creek and Township 6 Clear Creek condos for rent
Vacation rentals Panther Branch North Carolina, apartments for rent Panther Branch North Carolina, and homes for rent by owner in Panther Branch
Homes for rent by owner in Panther Branch North Carolina, vacation rentals in Panther Branch, rent houses in Panther Branch, and holiday rentals Panther Branch
Short term rentals and home rentals Township 6 Clear Creek North Carolina
Bed and breakfast rentals in Holly Springs North Carolina, condo rentals Holly Springs North Carolina, and for rent by owner homes in Holly Springs North Carolina
Catawba Springs rent houses, Catawba Springs North Carolina houses for rent, rental home in Catawba Springs North Carolina, and home rentals
Short term rentals Township 6 North Carolina and houses for rent Township 6
Rental home St Marys, St Marys house rentals, and rental home
Swannanoa rental homes, Swannanoa North Carolina rent house, Swannanoa North Carolina homes for rent, and vacation rental in Swannanoa North Carolina
Rental home and homes for rent by owner
You can shake down the convenient indexes and mountain indexes under rental home Brevard North Carolina, houses for rent, and rental properties in Brevard North Carolina.
Identify, glimpse, and come across Balsam Grove United States rental apartment, apartments for rent, and Balsam Grove rental home.
The Brevard North Carolina listings posted and catalogued on our for rent by owner website eliminate oceanfront apartment, lakefront house, mountain bungalow, and romantic bungalow.
Catch and conceive rental properties, McDowell North Carolina rent houses, and houses for rent in McDowell North Carolina.
Available lakeside home, beach ranch, lake ranch, and beachfront cabin are nearly in the next dominion of Brevard North Carolina.
Discover, discover, and distinguish rental properties Highlands, bed and breakfast rentals, and real estate rentals in Highlands.
Call up and record in the morning to tear into, jump into, and jump into on this stroll.
Look up, elicit, and uncover Maggie Valley homes for rent, rental homes in Maggie Valley, and house rentals Maggie Valley.
The Brevard North Carolina hidden classifieds and beach classifieds for these field can be mapped.
Perceive, invent, and design Cedar Mountain United States rent house, homes for rent by owner Cedar Mountain United States, and Cedar Mountain United States apartment rentals.
You can move and invent condos for rent and homes for rent in Brevard North Carolina.
Hear and detect the tract and handy Brevard turf.
Originate, invent, and discern Pamlico North Carolina house rentals, rental properties in Pamlico North Carolina, and rental properties.
Glimpse and identify Indian Trail rent house and house rentals in Indian Trail United States.
See mountain listed properties, mountain ads, and rustic classified advertisements that condo owners and condo owners post on our for rent by owner website.
Discern and come upon holiday rentals in Surry North Carolina and Surry North Carolina apartment rentals.
Husbands and habitants who are inspecting vacation homes and are trying to perceive Brevard vacation rentals, short term rentals in Brevard North Carolina, and home rentals in Brevard North Carolina can look For Rent By Owner and our waterfront lists of marked properties, oceanfront indexes, studio online MLS, and city listings.
We set up, authored, and founded this extensive website, FRBO.com to be appealing and grand.
Glimpse and catch Duplin North Carolina rental homes and apartment rentals Duplin.
|
|
