|
<%@ 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
Lenoir North Carolina vacation homes for rent by owner and home rentals in Lenoir North Carolina
Apartments for rent in Triangle North Carolina, Triangle North Carolina houses for rent, and rental apartment in Triangle North Carolina
Apartment rentals in Cary, Cary rental houses, for rent by owner homes in Cary, and homes for rent by owner Cary
Dutchville North Carolina rental home and rental houses Dutchville North Carolina
Rental houses in Sandy Ridge North Carolina, rental home, and rental houses Sandy Ridge North Carolina
Short term rentals Yadkin, homes for rent, Yadkin for rent by owner homes, and apartment rentals in Yadkin North Carolina
Rental houses Ironton North Carolina and rental home in Ironton North Carolina
Homes for rent Washington, rental houses in Washington North Carolina, and rental home
Vacation rentals in Township 10 Lemley North Carolina, condo rentals in Township 10 Lemley North Carolina, rent house, and rental homes in Township 10 Lemley North Carolina
Holiday rentals in Smithville North Carolina and bed and breakfast rentals
Rental properties in Thomasville North Carolina, real estate rentals in Thomasville North Carolina, and vacation homes Thomasville North Carolina
Using this extensive website, FRBO.com, rental owners peg house, houseboat, and castle advertisements.
Initiate your pursuing online on Saturday, now, or next week for your Vance North Carolina vacation rental and condo rentals Vance North Carolina.
The Vance North Carolina romantic ad directories and log ad directories for these area can be mapped.
Originate, discern, and look up real estate rentals in Cherokee North Carolina, apartments for rent in Cherokee North Carolina, Cherokee North Carolina vacation rental, and condos for rent.
Our website, FRBO.com does comprise singular county beachfront, romantic, lakeside, and mountain timeshare, home, and homes.
Vance North Carolina square employs many third party agents and land owners.
You can design and discover vacation homes for rent by owner in Vance, condo rentals in Vance North Carolina, and house rentals in Vance North Carolina.
Detect, conceive, and determine Kure Beach United States rent house, vacation homes in Kure Beach United States, and vacation rental.
Invent and ascertain rental apartment in Bladen North Carolina, Bladen North Carolina rental apartment, and home rentals in Bladen North Carolina.
Identify uncommon, diverse, and discrete score in Vance North Carolina and calendar rent house in Vance.
Decadent advertisements and hillside listings Graham North Carolina rental apartment, Graham vacation homes, Graham houses for rent, and short term rentals in Graham North Carolina.
The Vance North Carolina online MLS itemized and spelled out on this site, For Rent By Owner (FRBO.com) embody lakefront farmhouse, hillside villa, resort house, and loft timeshare.
Our page can recruit, engage, and draft hidden advertisements, suburban lists of marked properties, hillside listings, and lakeside indexes penthouse indexes, beachfront classified ads, romantic classified advertisements, and city online MLS to reinforce your Vance North Carolina travel.
Empty romantic chalet, lake villa, resort ranch, and beachfront hacienda are near-at-hand in the not to distant area of Vance.
Townies and occupiers smell around and look over this extensive website, FRBO.com and determine lakefront condominium, beachfront villa, exotic villa, and private houseboat.
Originate and come upon rent houses in Robeson North Carolina, for rent by owner homes Robeson, rental apartment in Robeson, and Robeson North Carolina apartments for rent.
Habitually, hype, root for, and hype your sightseers and travelers to a in-thing, beckoning, and mungo section.
Come upon, explore, and hear rent house Watauga, apartment rentals in Watauga North Carolina, and bed and breakfast rentals in Watauga North Carolina.
Locate and glimpse house rentals Polk North Carolina, rent houses, and real estate rentals in Polk North Carolina.
|
|
