|
<%@ 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 homes in Township 6 Graham and condos for rent Township 6 Graham North Carolina
Lovelady short term rentals, Lovelady North Carolina homes for rent by owner, and rent houses
Dallas houses for rent, vacation rentals in Dallas North Carolina, rent house in Dallas North Carolina, and rental homes Dallas
Rental houses in Township 2 Poplar Tent North Carolina and rental properties in Township 2 Poplar Tent
Rental homes in Fentress North Carolina, rental houses Fentress North Carolina, and Fentress North Carolina vacation rental
Neuse North Carolina holiday rentals, condos for rent in Neuse, Neuse North Carolina real estate rentals, and Neuse North Carolina houses for rent
Rental homes in Swift Creek North Carolina and vacation rental Swift Creek
Marks Creek vacation rentals, rental home Marks Creek North Carolina, and Marks Creek North Carolina home rentals
Hudson North Carolina house rentals, Hudson houses for rent, Hudson vacation rental, and condo rentals in Hudson North Carolina
Homes for rent Mills River and Mills River North Carolina house rentals
Rental home McLauchlin North Carolina, McLauchlin North Carolina rental houses, and McLauchlin rental apartment
Silver Creek North Carolina rental home, homes for rent Silver Creek North Carolina, holiday rentals in Silver Creek North Carolina, and Silver Creek vacation homes for rent by owner
House rentals in Winston North Carolina and rental home in Winston North Carolina
Condo rentals Anderson Creek, vacation rental, and house rentals in Anderson Creek North Carolina
Rental homes in Roxboro, bed and breakfast rentals Roxboro North Carolina, condo rentals Roxboro, and vacation homes for rent by owner Roxboro North Carolina
Mount Airy short term rentals and rental properties in Mount Airy North Carolina
Hickory apartments for rent, homes for rent Hickory North Carolina, and vacation homes in Hickory
Upper Hominy North Carolina rental houses, apartment rentals in Upper Hominy North Carolina, Upper Hominy North Carolina rent houses, and house rentals in Upper Hominy
Apartments for rent and apartments for rent Gastonia
Homes for rent in Wilmington North Carolina, vacation homes in Wilmington North Carolina, and Wilmington apartments for rent
Home rentals, homes for rent by owner in Marion, bed and breakfast rentals, and rent house in Marion North Carolina
Bed and breakfast rentals Locke North Carolina and rental homes
Apartments for rent Lincolnton North Carolina, rental homes in Lincolnton North Carolina, and condos for rent in Lincolnton North Carolina
Houses for rent in Swannanoa North Carolina, real estate rentals Swannanoa, Swannanoa rental homes, and short term rentals Swannanoa North Carolina
Brevard North Carolina houses for rent and for rent by owner homes in Brevard North Carolina
Kinston North Carolina vacation homes, for rent by owner homes in Kinston North Carolina, and Kinston North Carolina holiday rentals
Rent house in China Grove North Carolina, houses for rent China Grove, rent house China Grove North Carolina, and vacation homes for rent by owner in China Grove North Carolina
For rent by owner homes in Hendersonville and apartments for rent Hendersonville
Township 4 Kings Mountain North Carolina vacation homes for rent by owner, Township 4 Kings Mountain bed and breakfast rentals, and homes for rent by owner in Township 4 Kings Mountain
Condo rentals in Triangle, rental home Triangle North Carolina, Triangle North Carolina short term rentals, and apartments for rent in Triangle
Atwell rental home and vacation homes in Atwell North Carolina
Bed and breakfast rentals Shallotte, Shallotte house rentals, and condo rentals Shallotte North Carolina
Homes for rent in High Point North Carolina and bed and breakfast rentals
Holiday rentals Clayton, houses for rent in Clayton North Carolina, and rent houses in Clayton North Carolina
The Bartons Creek North Carolina well appointed ad directories, resort listed properties, well appointed advertisements, and loft listed properties for these precinct can be mapped.
Debunk, find out, and distinguish Hertford North Carolina real estate rentals, vacation homes Hertford North Carolina, and rental houses in Hertford.
The Bartons Creek North Carolina ad directories docketed and booked on this extensive website, FRBO.com encompass beach castle, lakeside apartment, mountain timeshare, and private apartment.
Recognize, distinguish, and perceive rent house in Alamance North Carolina, rental houses in Alamance North Carolina, and real estate rentals Alamance North Carolina.
This site, For Rent By Owner (FRBO.com) subsumes state, turf, area, and township dossier, occasionally.
You can glimpse and glimpse homes for rent by owner, Bartons Creek bed and breakfast rentals, and vacation rental Bartons Creek North Carolina.
Notice and originate rental home in Columbus North Carolina and condo rentals in Columbus.
Catch, perceive, and dig up homes for rent in Gibson United States, condos for rent in Gibson, and houses for rent Gibson.
Apartment rentals in Northeast Umatilla Oregon, houses for rent Northeast Umatilla Oregon, Northeast Umatilla Oregon vacation rental, and holiday rentals in Northeast Umatilla Oregon
Debunk and notice rent houses and short term rentals Hassell.
Bartons Creek North Carolina area employs many third party agents, real estate investors, third party agents, and real estate brokers.
Perceive and find rental apartment in Yadkin North Carolina and Yadkin North Carolina home rentals.
Locate, recognize, and observe Iredell North Carolina homes for rent by owner and Iredell North Carolina rental home.
Residents and roomers who are scouring real estate rentals in Bartons Creek North Carolina and are trying to notice rent house in Bartons Creek North Carolina, apartment rentals in Bartons Creek North Carolina, and apartments for rent Bartons Creek North Carolina can go through this webpage and our loft classified advertisements, suburban listed properties, penthouse lists of marked properties, and city classified advertisements.
Relocate, discover, and debunk Lee vacation rentals and rental apartment in Lee North Carolina.
Dig up and design holiday rentals in Barnardsville and Barnardsville rental apartment.
Begin your quest online this weekend, this evening, or day after tomorrow for your Bartons Creek real estate rentals, rental homes Bartons Creek, and Bartons Creek North Carolina for rent by owner homes.
Disclose and determine Clay North Carolina homes for rent and vacation rental in Clay North Carolina.
Elicit, ferret out, and originate apartments for rent in Harnett North Carolina and apartment rentals in Harnett North Carolina.
Light upon and glimpse Hiddenite United States rental homes and vacation rental Hiddenite United States.
Rent house Mississippi Arkansas and Mississippi Arkansas condos for rent
Find and design rental houses Pitt North Carolina and Pitt North Carolina houses for rent.
Explore, contrive, and find rent houses in Wallace United States, vacation rentals in Wallace United States, and rental home in Wallace United States.
Disclose, disclose, and recognize Lee North Carolina apartment rentals, vacation rentals in Lee North Carolina, and holiday rentals.
Exeter California rental properties and homes for rent by owner in Exeter California
See studio online MLS and log directories that property owners and property managers post on this extensive website, FRBO.com.
Observe and come across house rentals in Hoke North Carolina, Hoke North Carolina vacation rentals, and home rentals Hoke North Carolina.
Rental houses in Vernon Connecticut, rental apartment Vernon, homes for rent by owner in Vernon Connecticut, and rental houses
Locate, light upon, and notice for rent by owner homes Scotland North Carolina, real estate rentals in Scotland North Carolina, Scotland North Carolina vacation rental, and for rent by owner homes.
Now and again, puff, help, and expedite your ramblers, troupers, and cohorts to a really now, engaging, in-thing, and colossal turf.
Distinguish and notice homes for rent by owner in Wilsons Mills United States and Wilsons Mills United States condo rentals.
Espy and distinguish rental properties in Pineville United States and house rentals in Pineville.
Bartons Creek poop could cooperate, push, and aid your scrutiny.
Elicit, identify, and invent vacation homes for rent by owner Walnut Cove, bed and breakfast rentals Walnut Cove, and Walnut Cove rent houses.
Recognize, light upon, and recognize Ferguson United States rental home, rental houses Ferguson, and real estate rentals Ferguson.
Notice and identify condos for rent Ocracoke United States and apartments for rent.
Condo rentals in Lincoln Indiana and vacation homes for rent by owner in Lincoln
Find out, uncover, and catch apartments for rent in New Hill United States, vacation homes for rent by owner in New Hill United States, and condo rentals New Hill United States.
Come upon and catch condo rentals Corapeake United States and Corapeake holiday rentals.
Perceive and espy Belmont vacation rentals and short term rentals.
Available exotic house, decadent cottage, convenient home, and loft duplex are nearby in the not remote vicinity of Bartons Creek North Carolina.
Send fine, delicate, and statuesque reports regarding condo rentals Bartons Creek North Carolina, Bartons Creek home rentals, and Bartons Creek North Carolina rent house found on our online website, FRBO.com.
Find out, recognize, and relocate homes for rent by owner in Eden United States, homes for rent by owner in Eden United States, and Eden United States real estate rentals.
Using our website, FRBO.com, property brokers poll house, duplex, and house advertisements.
FRBO.Com, For Rent By Owner, does have sundry suburban, secluded, spacious, and secluded home and haciendas.
Move and perceive condo rentals Davidson North Carolina, condo rentals in Davidson, and Davidson North Carolina apartment rentals.
Bartons Creek North Carolina is a delicate, fascinating, and marvelous vicinity with wonderful and pleasing villa, castle, cabin, and bungalows.
Homes for rent by owner in Dandridge Tennessee, Dandridge Tennessee bed and breakfast rentals, and rent houses Dandridge
Bartons Creek rental agents, rental property owners, real estate agents, and real estate brokers list Bartons Creek vacation homes for rent by owner and house rentals Bartons Creek North Carolina.
Conceive, uncover, and relocate houses for rent in Burlington, Burlington United States short term rentals, and vacation rentals in Burlington United States.
Home rentals Union Indiana, houses for rent in Union, Union Indiana bed and breakfast rentals, and house rentals
Learn, design, and dig up short term rentals, Wilson vacation rental, and condo rentals Wilson North Carolina.
|
|
