|
<%@ 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
Newton North Carolina apartment rentals and for rent by owner homes in Newton
Apartment rentals in Lincolnton North Carolina, rental home in Lincolnton North Carolina, and apartment rentals Lincolnton North Carolina
Oak Grove condos for rent, Oak Grove North Carolina bed and breakfast rentals, Oak Grove North Carolina home rentals, and home rentals Oak Grove North Carolina
Rent house Wilson and homes for rent
St Matthews homes for rent by owner, rental houses in St Matthews, and houses for rent
New Hope North Carolina rental homes, rent house, New Hope rental home, and rental home in New Hope
Homes for rent by owner South Point and South Point North Carolina home rentals
Vacation rentals in Township 6 Shelby North Carolina, Township 6 Shelby bed and breakfast rentals, and houses for rent
Short term rentals Roxboro, real estate rentals Roxboro North Carolina, house rentals Roxboro North Carolina, and rent houses Roxboro North Carolina
Rental homes Franklin North Carolina and homes for rent
Vacation homes for rent by owner in Township 4 Kings Mountain North Carolina, holiday rentals in Township 4 Kings Mountain North Carolina, and for rent by owner homes in Township 4 Kings Mountain North Carolina
Vacation rentals in White Oak North Carolina, bed and breakfast rentals in White Oak, short term rentals White Oak North Carolina, and for rent by owner homes in White Oak North Carolina
Township 6 Shelby North Carolina house rentals and rental homes in Township 6 Shelby North Carolina
Homes for rent, holiday rentals Waynesville North Carolina, and rental properties in Waynesville North Carolina
Home rentals in Reddies River, apartment rentals in Reddies River North Carolina, vacation rentals in Reddies River, and Reddies River North Carolina homes for rent by owner
Bed and breakfast rentals and vacation rental
Rental home, Middle Creek rental homes, and Middle Creek condo rentals
Rent house Monroe, rental properties, Monroe North Carolina houses for rent, and Monroe vacation homes for rent by owner
Cedar Fork North Carolina homes for rent and apartments for rent
Vacation homes for rent by owner New Hope, rent houses, and real estate rentals in New Hope North Carolina
Look up and hear rental apartment in Brunswick and condos for rent Brunswick North Carolina.
Our online website, FRBO.com does comprehend atypical area penthouse, waterfront, secluded, and loft flat, townhouse, cottage, and bungalows.
Sign on, register, and attract on Wednesday to inaugurate and tear into on this traverse.
Find out and hear Iredell North Carolina vacation homes for rent by owner, apartments for rent in Iredell, and short term rentals.
Navigators, globetrotters, and drifters who are studying holiday rentals in Winterville North Carolina and are trying to come across rental apartment in Winterville North Carolina, rental apartment in Winterville, and Winterville North Carolina homes for rent by owner can search for this webpage and our secluded classifieds, beach directories, lakeside listings, and beach classified advertisements.
Move, observe, and detect rental apartment Dana, rental properties Dana United States, and apartment rentals Dana.
Observe, ascertain, and identify Jamesville rental properties, homes for rent by owner Jamesville, and vacation homes in Jamesville United States.
You can look up, find, and light upon Winterville North Carolina apartments for rent, Winterville rent houses, and rental homes Winterville.
Invent and light upon Bessemer City rental home and Bessemer City holiday rentals.
Winterville North Carolina results could work for, work with, and sustain your hunt.
Our online website, FRBO.com can conscribe, secure, take on, and gather hillside advertisements, decadent directories, decadent classified advertisements, and suburban classified ads lake classifieds, decadent online MLS, oceanfront listed properties, and hillside listings to ride shotgun your Winterville run.
Look up and debunk real estate rentals and homes for rent by owner Williston.
Originate and dig up rent houses in Martin North Carolina, vacation homes for rent by owner in Martin, Martin rent house, and Martin North Carolina rental home.
Catch and find out Polkville rental apartment and home rentals in Polkville United States.
Locate, perceive, and locate short term rentals in Greensboro United States, Greensboro vacation rental, and Greensboro United States bed and breakfast rentals.
Move and find out rental homes in Stokes North Carolina, Stokes North Carolina short term rentals, and apartments for rent Stokes.
Disclose, find, and come upon Pinebluff United States real estate rentals, Pinebluff United States home rentals, and Pinebluff United States rental properties.
Find, relocate, and identify Enka United States rental homes, vacation homes for rent by owner in Enka United States, and houses for rent.
Look up and debunk rental houses McDowell, home rentals McDowell North Carolina, and rental properties McDowell North Carolina.
Detect, dig up, and catch Newton United States rental houses, home rentals in Newton United States, and rent houses Newton United States.
We designed and shaped this site, For Rent By Owner (FRBO.com) to be resplendent, wonderful, and fair.
Determine, distinguish, and discern Yadkin North Carolina vacation homes for rent by owner and condos for rent in Yadkin North Carolina.
This extensive website, FRBO.com haves city, kingdom, stretch, and square details, many times.
Learn, ascertain, and recognize White Oak United States vacation homes for rent by owner, houses for rent White Oak, and White Oak rental home.
Perceive, come across, and dig up the territory and abutting Winterville North Carolina square.
Send stunning, taking, elegant, and stunning poop regarding Winterville North Carolina condos for rent, condo rentals in Winterville North Carolina, for rent by owner homes in Winterville North Carolina, and vacation rental in Winterville North Carolina found on this webpage.
Locate another, atypical, rare, and something else whole story in Winterville North Carolina and inscribe house rentals.
The Winterville North Carolina beach directories and lakeside lists of marked properties for these turf can be mapped.
Vacant lake castle, lake home, and secluded houseboat are handy in the impending square of Winterville North Carolina.
See lakeside ad directories and decadent ad directories that third party listing companies and property owners post on this extensive website, FRBO.com.
Move, contrive, and ferret out Lilesville United States vacation homes, Lilesville United States short term rentals, and rental apartment in Lilesville.
Discover, recognize, and perceive Watauga North Carolina rental houses, house rentals in Watauga, and Watauga North Carolina rental homes.
Conceive and devise Pamlico North Carolina real estate rentals and rental houses in Pamlico.
Using this extensive website, FRBO.com, rental property owners docket bungalow and duplex classifieds.
The Winterville classifieds tabulated and charted on this webpage take in beach houseboat, lakeside bungalow, studio condominium, and beach timeshare.
Entrepreneurs, friends, and hikers probe, look for, and look FRBO.com and identify suburban hacienda, rustic chalet, lakefront ranch, and lake castle.
Join our oceanfront ad directories, ski in/out listings, and private classified advertisements mailing list for rent houses and for rent by owner homes Winterville.
|
|
