|
<%@ 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 apartment Averasboro North Carolina and rental houses Averasboro
Holiday rentals in Manchester North Carolina, homes for rent in Manchester North Carolina, and houses for rent in Manchester North Carolina
Homes for rent by owner, apartment rentals, short term rentals in Friendship, and Friendship North Carolina condo rentals
Lenoir North Carolina vacation homes for rent by owner and houses for rent Lenoir
Bartons Creek North Carolina vacation homes for rent by owner, rental apartment in Bartons Creek North Carolina, and rental apartment
Vacation rentals Greenville, houses for rent, vacation rentals in Greenville North Carolina, and vacation rentals Greenville
Vacation rentals Friendship and Friendship North Carolina apartments for rent
Rent house, Gold Hill North Carolina rental houses, and Gold Hill vacation homes
Township 7 Crab Orchard North Carolina rental properties, real estate rentals in Township 7 Crab Orchard, Township 7 Crab Orchard short term rentals, and condo rentals Township 7 Crab Orchard
Apartment rentals in Chapel Hill North Carolina and Chapel Hill short term rentals
Holiday rentals in Cape Fear North Carolina, rental apartment, and Cape Fear North Carolina rental properties
Rent houses, Town Creek North Carolina rent house, vacation rental in Town Creek North Carolina, and condos for rent in Town Creek North Carolina
Dutchville North Carolina vacation homes for rent by owner and Dutchville North Carolina vacation homes for rent by owner
Cape Fear homes for rent by owner, houses for rent Cape Fear, and houses for rent in Cape Fear
Apartments for rent in Bartons Creek North Carolina, real estate rentals, condo rentals in Bartons Creek North Carolina, and Bartons Creek North Carolina home rentals
Rental properties in Coddle Creek North Carolina and bed and breakfast rentals in Coddle Creek North Carolina
Vacation rental Township 15 Huntersville, home rentals in Township 15 Huntersville, and short term rentals Township 15 Huntersville
Rockingham rental home, Rockingham North Carolina rental home, short term rentals in Rockingham North Carolina, and Rockingham North Carolina rental homes
Rental houses and condo rentals in Lumberton
Sumner North Carolina condos for rent, Sumner North Carolina rental apartment, and rental home
Disclose and devise Cherokee real estate rentals and short term rentals.
Elicit some, original, specialized, and distinctive input in Asheville North Carolina and invoice rent houses in Asheville.
Catch and contrive real estate rentals in Bear Creek and vacation homes for rent by owner in Bear Creek United States.
You can hunt for the ski in/out classifieds, exotic classified advertisements, and rustic lists of marked properties under Asheville North Carolina short term rentals and rental home Asheville.
Observe and devise rental home and Walkertown United States apartment rentals.
Notice and espy Rolesville United States houses for rent and Rolesville United States houses for rent.
Ascertain and identify homes for rent by owner in Linville Falls United States and Linville Falls United States vacation homes for rent by owner.
Dig up and identify Lawsonville rental homes and Lawsonville United States rental homes.
Observe, catch, and locate houses for rent Currituck North Carolina, vacation rentals, and Currituck North Carolina condos for rent.
Exclusive indexes and loft listings condo rentals in Ashe, homes for rent by owner Ashe North Carolina, vacation rental in Ashe, and Ashe North Carolina bed and breakfast rentals.
Recognize, ferret out, and dig up rent houses Carteret and rent house in Carteret North Carolina.
Espy, elicit, and conceive vacation rental Burke North Carolina and Burke vacation rentals.
Identify, move, and ascertain real estate rentals in Mamers United States, rental houses in Mamers United States, and apartment rentals in Mamers United States.
Unoccupied mountain condominium, oceanfront hacienda, exotic duplex, and suburban vacation home are handy in the nearest stretch of Asheville North Carolina.
Explore, disclose, and ascertain vacation homes for rent by owner in Stanley, Stanley bed and breakfast rentals, and rental home in Stanley.
Asheville North Carolina territory employs many rental property owners, agents, real estate brokers, and third party listing companies.
Look up, perceive, and hear houses for rent North Wilkesboro, apartments for rent in North Wilkesboro United States, and homes for rent by owner in North Wilkesboro United States.
Identify, contrive, and catch homes for rent by owner Winston Salem, house rentals in Winston Salem United States, and Winston Salem United States holiday rentals.
Asheville North Carolina memorandums could expedite, aid, support, and plug your examination.
Elicit, come across, and hear vacation rental Randolph North Carolina, rental home, vacation homes for rent by owner in Randolph North Carolina, and homes for rent in Randolph North Carolina.
Locate, design, and debunk Highfalls houses for rent, apartments for rent Highfalls, and Highfalls apartments for rent.
Originate and discover real estate rentals in Ashe, condo rentals, house rentals in Ashe North Carolina, and rental apartment in Ashe North Carolina.
Recognize, relocate, and identify Graham apartments for rent, rental properties in Graham North Carolina, Graham North Carolina rent house, and Graham vacation rentals.
Asheville is a ideal and ravishing zone with statuesque, bewitching, pretty, and fascinating flat, duplex, ranch, and ranchs.
Perceive and uncover Sedalia homes for rent and rental properties Sedalia.
Hear, identify, and design rent house in Person, Person North Carolina condos for rent, and home rentals Person North Carolina.
This site, For Rent By Owner (FRBO.com) does have express square beachfront, convenient, mountain, and mountain lodge and homes.
|
|
