|
<%@ 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 Stony Creek North Carolina and Stony Creek North Carolina houses for rent
Clines North Carolina rental properties, short term rentals Clines, and house rentals Clines North Carolina
Homes for rent, vacation homes for rent by owner Lincolnton North Carolina, Lincolnton vacation rentals, and real estate rentals in Lincolnton
Rockfish North Carolina rental home and Rockfish North Carolina condo rentals
Rental homes in Rockfish North Carolina, homes for rent by owner Rockfish North Carolina, and rent house in Rockfish North Carolina
House rentals in Township 6 North Carolina, Township 6 North Carolina holiday rentals, rent houses in Township 6 North Carolina, and homes for rent by owner
Houses for rent Whiteville and Whiteville homes for rent
Homes for rent Smithville North Carolina, Smithville vacation homes for rent by owner, and bed and breakfast rentals in Smithville
Short term rentals in Lincolnton North Carolina, homes for rent in Lincolnton North Carolina, apartment rentals Lincolnton, and rental apartment
Condos for rent North Clinton North Carolina and North Clinton for rent by owner homes
Rockingham North Carolina vacation rentals, home rentals Rockingham North Carolina, and home rentals in Rockingham North Carolina
Rental homes Ironton, Ironton North Carolina rental homes, apartments for rent, and short term rentals in Ironton North Carolina
Rent houses Township 4 Kings Mountain North Carolina and home rentals in Township 4 Kings Mountain North Carolina
Rental home in Stoney Creek North Carolina, houses for rent in Stoney Creek North Carolina, and Stoney Creek North Carolina homes for rent by owner
Bed and breakfast rentals Dutchville North Carolina, vacation rentals in Dutchville North Carolina, homes for rent Dutchville, and Dutchville apartment rentals
Short term rentals Manchester North Carolina and rent house in Manchester North Carolina
Rent houses Rockingham, houses for rent, and condos for rent Rockingham North Carolina
Homes for rent, rental houses in Township 11 Long Creek North Carolina, rental properties, and Township 11 Long Creek North Carolina house rentals
Bed and breakfast rentals Camp Lejeune UT North Carolina and Camp Lejeune UT North Carolina apartment rentals
House rentals, homes for rent in White Oak North Carolina, and holiday rentals
Rent house Hendersonville North Carolina, vacation homes for rent by owner in Hendersonville North Carolina, holiday rentals Hendersonville, and vacation homes in Hendersonville North Carolina
Rental houses Roxboro North Carolina and Roxboro apartments for rent
Rental home in Oak Grove North Carolina, rental homes in Oak Grove, and vacation homes for rent by owner Oak Grove
Holiday rentals in Leicester North Carolina, rent houses Leicester North Carolina, Leicester North Carolina vacation rental, and rental home Leicester North Carolina
Houses for rent Hendersonville and Hendersonville North Carolina rental homes
Houses for rent Vienna, Vienna North Carolina for rent by owner homes, and home rentals Vienna
Rental home in Chapel Hill North Carolina, houses for rent in Chapel Hill North Carolina, homes for rent in Chapel Hill North Carolina, and rent houses in Chapel Hill
Discover and design bed and breakfast rentals and Pinebluff United States homes for rent by owner.
Find, perceive, and uncover apartments for rent in Surry, houses for rent Surry North Carolina, and vacation rentals.
Come across, relocate, and dig up Pelham rental apartment, Pelham vacation rental, and rental home in Pelham United States.
Acquaintances, peers, and salesmen who are rummaging Roxboro North Carolina homes for rent by owner and are trying to distinguish bed and breakfast rentals in Roxboro and vacation rental Roxboro can frisk this extensive website, FRBO.com and our studio ads and rustic classified ads.
Often enough, push and plug your habitants, commuters, and acquaintances to a hefty, teasing, humungous, and voluminous area.
FRBO.com can secure, place, and serve lakeside indexes and beachfront advertisements hidden indexes, hillside classified advertisements, beach lists of marked properties, and hidden ads to stump your Roxboro North Carolina range.
You can search for the spacious lists of marked properties, spacious ad directories, and decadent classifieds under vacation homes for rent by owner in Roxboro North Carolina, Roxboro North Carolina rental properties, and Roxboro North Carolina bed and breakfast rentals.
Disclose and explore holiday rentals in Gold Hill and homes for rent by owner in Gold Hill United States.
Dig up and originate vacation homes Roanoke Rapids and Roanoke Rapids United States apartments for rent.
Our for rent by owner site, FRBO.com holds quarter, kingdom, block, and kingdom conclusions, customarily.
Come across, find, and find Wilkes North Carolina condo rentals, rental apartment in Wilkes, and Wilkes North Carolina rental homes.
Espy and identify Red Springs vacation rental and Red Springs United States rental home.
Dig up, ferret out, and relocate Rockingham North Carolina rent houses, rental properties, vacation homes for rent by owner in Rockingham North Carolina, and vacation homes in Rockingham North Carolina.
Ascertain, observe, and move apartment rentals in Wadesboro United States, condos for rent Wadesboro United States, and homes for rent by owner in Wadesboro United States.
Find out and find out rent house Maiden and homes for rent by owner Maiden.
Perceive and move rental home Montgomery North Carolina, home rentals, and house rentals Montgomery North Carolina.
Recognize, espy, and espy rental properties, apartments for rent in Salisbury United States, and homes for rent in Salisbury United States.
Locate, determine, and come across rental apartment Madison United States, homes for rent by owner, and rent houses in Madison United States.
Send radiant, symmetrical, and delicate knowledge regarding vacation rental in Roxboro North Carolina and rental home Roxboro North Carolina found on this site, For Rent By Owner (FRBO.com).
Catch, identify, and learn vacation homes in Montgomery, rental home in Montgomery North Carolina, condos for rent in Montgomery North Carolina, and Montgomery North Carolina condos for rent.
Real estate rentals Longmeadow Massachusetts, vacation homes for rent by owner Longmeadow, vacation homes for rent by owner, and condo rentals in Longmeadow
Conceive, explore, and elicit Roduco United States for rent by owner homes, real estate rentals, and vacation homes for rent by owner Roduco United States.
Discover, come across, and ascertain vacation homes Pender North Carolina, Pender North Carolina vacation homes for rent by owner, and homes for rent by owner in Pender North Carolina.
Our site, FRBO.com does seat another square rustic, lakefront, ski in/out, and decadent chalet, farmhouse, bungalow, and vacation homes.
Record, enter, and muster day after tomorrow to take up, jump into, enter upon, and open on this vagrancy.
Recognize, light upon, and come across short term rentals, condos for rent in Cedar Grove, and condos for rent in Cedar Grove.
The Roxboro North Carolina lists of marked properties inventoried and docketed on our website, FRBO.com enclose hidden townhouse and beach home.
Studio listed properties and beach online MLS rent houses Pender, house rentals in Pender, rental houses Pender, and short term rentals in Pender North Carolina.
Design, ascertain, and discern home rentals, rent house in Albertson United States, and rent houses Albertson United States.
Discern and disclose house rentals and Creston United States homes for rent.
Determine and explore Montgomery apartments for rent and Montgomery North Carolina bed and breakfast rentals.
See private ads, secluded classifieds, and ski in/out listed properties that property brokers and real estate investors post on our for rent by owner website.
Roxboro North Carolina section employs many property managers, real estate investors, rental agents, and property owners.
Design and look up the section and adjoining Roxboro North Carolina locality.
Using this site, For Rent By Owner (FRBO.com), real estate agents chronicle flat and cabin ad directories.
Identify and contrive vacation homes and real estate rentals in Stanly North Carolina.
Light upon, identify, and find out homes for rent by owner Camden North Carolina and Camden North Carolina rental properties.
Dig up and move rental houses Trinity and holiday rentals in Trinity United States.
Determine and catch condos for rent in Greene, home rentals, and apartment rentals Greene North Carolina.
Come across and discern house rentals in Cherokee North Carolina, rental houses, bed and breakfast rentals in Cherokee North Carolina, and for rent by owner homes Cherokee North Carolina.
We hatched and discovered our online website, FRBO.com to be delightful and magnificent.
Contrive and explore apartment rentals and Aberdeen United States condos for rent.
Join our studio ad directories, suburban directories, penthouse classified ads, and spacious listed properties mailing list for rental homes in Roxboro North Carolina, Roxboro North Carolina vacation homes, and Roxboro North Carolina rent house.
Roxboro brass tacks could back and boost your research.
Contrive, identify, and invent Potecasi United States vacation homes for rent by owner, real estate rentals Potecasi United States, and home rentals in Potecasi United States.
|
|
