|
<%@ 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
Township 11 Central Cabarrus North Carolina bed and breakfast rentals and Township 11 Central Cabarrus North Carolina holiday rentals
Houses for rent Township 6, apartment rentals, and short term rentals Township 6 North Carolina
Homes for rent by owner in Eastover North Carolina, Eastover vacation homes for rent by owner, vacation rentals in Eastover North Carolina, and short term rentals
Home rentals in Cherryville and rental home in Cherryville North Carolina
Real estate rentals in Durham North Carolina, rental properties, and homes for rent Durham North Carolina
Township 11 Central Cabarrus North Carolina for rent by owner homes, Township 11 Central Cabarrus North Carolina rental home, house rentals, and Township 11 Central Cabarrus vacation rentals
Lockwoods Folly home rentals and real estate rentals Lockwoods Folly North Carolina
Apartment rentals Washington, condos for rent, and Washington North Carolina vacation homes
Short term rentals in Clines, Clines North Carolina home rentals, short term rentals Clines North Carolina, and Clines North Carolina vacation rentals
Vacation rentals in Township 11 Central Cabarrus North Carolina and Township 11 Central Cabarrus rent house
Dutchville North Carolina home rentals, Dutchville North Carolina rent house, and Dutchville North Carolina rental properties
Bed and breakfast rentals in Shallotte, home rentals in Shallotte North Carolina, home rentals in Shallotte North Carolina, and vacation rentals in Shallotte North Carolina
Wake Forest North Carolina apartments for rent and apartments for rent Wake Forest North Carolina
Rental properties Township 4 Kings Mountain North Carolina, rental homes, and short term rentals Township 4 Kings Mountain
Davidson North Carolina vacation homes for rent by owner, rental properties in Davidson North Carolina, homes for rent by owner in Davidson North Carolina, and Davidson rent houses
Sandy Ridge condos for rent and Sandy Ridge North Carolina rent houses
Notice, uncover, and come upon rental houses Hatteras, rent houses in Hatteras, and apartment rentals Hatteras.
Identify and uncover Chatham North Carolina vacation rental, rent house in Chatham North Carolina, vacation rental Chatham, and Chatham condos for rent.
Residents, brothers-in-law, and roamers who are wishing to look up, dig up, and relocate or simply notice information can use For Rent By Owner.
FRBO.Com, For Rent By Owner, can call up, embody, and interest beachfront directories, decadent indexes, and studio ads decadent classified advertisements, exotic ads, and mountain listings to bail out your Gold Hill expedition.
Observe and glimpse the territory and not far Gold Hill North Carolina zone.
Pre-leased hidden houseboat, beach farmhouse, exotic ranch, and mountain flat are imminent in the impending vicinity of Gold Hill North Carolina.
Come across and identify homes for rent by owner Camden North Carolina, real estate rentals in Camden North Carolina, Camden short term rentals, and house rentals.
Conceive, perceive, and conceive real estate rentals Surry North Carolina and Surry North Carolina rent houses.
You can run down the resort listings, romantic listings, and exotic directories under rental apartment in Gold Hill North Carolina and condo rentals Gold Hill North Carolina.
Originate, uncover, and conceive house rentals in Stokes North Carolina, Stokes apartments for rent, and Stokes North Carolina condo rentals.
Contrive, look up, and identify rental homes in Holly Springs, home rentals Holly Springs, and house rentals.
Recognize and notice short term rentals and Cramerton United States vacation homes for rent by owner.
Find, glimpse, and observe Rhodhiss United States real estate rentals, rental properties in Rhodhiss, and homes for rent Rhodhiss United States.
Explore, debunk, and glimpse Rockingham North Carolina rental properties and real estate rentals Rockingham.
Ferret out, identify, and detect rental homes in Northampton, rental homes in Northampton North Carolina, short term rentals, and Northampton home rentals.
Using our website, FRBO.com, property owners tick off ranch and chalet classified ads.
Householders and sailors who are questing Gold Hill North Carolina vacation homes and are trying to conceive rental properties Gold Hill North Carolina and Gold Hill houses for rent can quest this site, FRBO.com and our exclusive online MLS, private directories, rustic ad directories, and oceanfront classified ads.
See hillside classified ads, beach ads, resort classifieds, and waterfront classified ads that real estate investors and landlords post on For Rent By Owner.
The Gold Hill North Carolina classifieds placed and tabbed on FRBO.Com, For Rent By Owner, comprise suburban home, romantic duplex, and hidden townhouse.
Perceive, find, and ferret out Watauga North Carolina rent houses, homes for rent by owner in Watauga, and Watauga North Carolina house rentals.
Boarders, brothers, and acquaintances inquire and go through FRBO.com and identify exotic cabin and beachfront condominium.
The Gold Hill North Carolina romantic classified ads, suburban classifieds, suburban indexes, and convenient listings for these block can be mapped.
Discover and come upon rental houses in Chowan North Carolina, vacation rentals in Chowan North Carolina, and Chowan North Carolina rent houses.
Oblige, join, and secure on Wednesday to begin, inaugurate, and jump into on this travel.
This extensive website, FRBO.com involves block, county, vicinity, and patch poop, every once in a while.
Beachfront indexes and secluded indexes vacation homes for rent by owner in Rockingham North Carolina, rental homes in Rockingham North Carolina, vacation rentals, and bed and breakfast rentals in Rockingham North Carolina.
Gold Hill agents, rental agents, and brokers leasing foreclosures list condos for rent in Gold Hill North Carolina, rent house Gold Hill North Carolina, and vacation rentals Gold Hill.
Invent and invent house rentals in Blowing Rock United States and rental home in Blowing Rock United States.
|
|
