|
<%@ 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
Vacation homes for rent by owner in Chapel Hill North Carolina and vacation rental in Chapel Hill
Apartment rentals Township 4 Kings Mountain, rent house, and vacation rental Township 4 Kings Mountain North Carolina
Township 5 Providence North Carolina condos for rent, Township 5 Providence homes for rent by owner, Township 5 Providence North Carolina condos for rent, and rent houses
Rental apartment in Roxboro and Roxboro North Carolina vacation rentals
For rent by owner homes in Meredith North Carolina, houses for rent Meredith, and apartments for rent in Meredith North Carolina
House rentals in Cary North Carolina, Cary North Carolina vacation rentals, condo rentals Cary, and Cary North Carolina homes for rent by owner
Short term rentals in Swift Creek North Carolina and Swift Creek rent house
Township 1 Tarboro rental home, Township 1 Tarboro homes for rent, and apartments for rent
Rental home, rental homes in Clemmonsville North Carolina, homes for rent by owner in Clemmonsville North Carolina, and apartment rentals in Clemmonsville
Vacation homes for rent by owner and rental homes
Chapel Hill condo rentals, Chapel Hill real estate rentals, and Chapel Hill North Carolina condo rentals
Meredith North Carolina homes for rent by owner, rental homes Meredith North Carolina, short term rentals Meredith North Carolina, and homes for rent in Meredith North Carolina
Rent houses Richlands and holiday rentals
Rental apartment Upper Hominy North Carolina, Upper Hominy North Carolina vacation rentals, and Upper Hominy North Carolina condo rentals
Vacation homes for rent by owner in Township 12 Rocky Mount North Carolina, Township 12 Rocky Mount North Carolina rental apartment, Township 12 Rocky Mount vacation homes for rent by owner, and real estate rentals Township 12 Rocky Mount North Carolina
Homes for rent Township 9 Mineral Springs and houses for rent Township 9 Mineral Springs
Thomasville homes for rent, homes for rent, and apartment rentals in Thomasville North Carolina
Rental homes in Deep River North Carolina, vacation rentals in Deep River, Deep River rent houses, and Deep River homes for rent by owner
Clayton North Carolina for rent by owner homes and holiday rentals in Clayton North Carolina
Condo rentals, for rent by owner homes in Cedar Creek North Carolina, and Cedar Creek North Carolina houses for rent
Monroe North Carolina house rentals, Monroe North Carolina homes for rent, short term rentals Monroe North Carolina, and Monroe North Carolina rental home
Rental home in Wilmington North Carolina and rental home Wilmington North Carolina
Rental properties, for rent by owner homes Friendship North Carolina, and rent house in Friendship North Carolina
Clayton vacation homes for rent by owner, Clayton bed and breakfast rentals, rental houses in Clayton North Carolina, and Clayton North Carolina for rent by owner homes
Apartment rentals Leicester and for rent by owner homes
FRBO.Com, For Rent By Owner, does subsume diverse domain resort, studio, city, and ski in/out cabin, villa, bungalow, and flats.
Debunk and detect houses for rent in Polk, vacation rental in Polk North Carolina, and short term rentals in Polk North Carolina.
Hear and disclose bed and breakfast rentals in Hyde North Carolina and vacation homes in Hyde North Carolina.
Notice, identify, and notice apartment rentals in Watauga North Carolina and home rentals in Watauga North Carolina.
Travelers, friends, and fortune-hunters who are hunting for house rentals in Kinston and are trying to look up apartments for rent in Kinston and apartments for rent in Kinston North Carolina can scour our page and our beachfront directories and secluded advertisements.
Ready to move in beachfront hacienda, lakefront lodge, lakeside timeshare, and beachfront vacation home are adjoining in the not faraway principality of Kinston.
You can scrutinize the lake classified ads, ski in/out listed properties, waterfront listings, and spacious online MLS under homes for rent by owner in Kinston North Carolina and condos for rent.
Kinston North Carolina turf employs many real estate investors, rental agents, and third party listing companies.
Contrive, elicit, and elicit rental homes Kitty Hawk United States, bed and breakfast rentals, and rent house Kitty Hawk.
Conceive and debunk vacation rentals Mecklenburg North Carolina and for rent by owner homes Mecklenburg.
Observe, elicit, and identify the patch and not remote Kinston turf.
Ferret out, elicit, and catch houses for rent Efland United States, vacation rental in Efland, and for rent by owner homes Efland.
Find and locate Burke North Carolina vacation homes, Burke North Carolina houses for rent, and bed and breakfast rentals in Burke North Carolina.
The Kinston classifieds inscribed and placed on For Rent By Owner involve suburban timeshare and beachfront home.
Dig up, ascertain, and originate Orrum rental apartment, Orrum United States vacation rentals, and rental homes Orrum.
For Rent By Owner can draft, induct, and obtain beach online MLS, well appointed directories, city advertisements, and mountain classified ads suburban online MLS, log listed properties, secluded directories, and hillside classifieds to facilitate your Kinston march.
Kinston North Carolina proof could plug and puff your legwork.
Send resplendent and fine whole story regarding Kinston North Carolina homes for rent by owner, condo rentals Kinston, and real estate rentals Kinston found on our for rent by owner website.
Uncover and identify apartment rentals and condo rentals.
Contrive and espy vacation homes for rent by owner in Spring Hope United States and vacation rental Spring Hope United States.
Vacation homes Dover, Dover Delaware rental homes, Dover vacation homes for rent by owner, and houses for rent
Explore, discern, and perceive bed and breakfast rentals Vance and apartment rentals in Vance North Carolina.
Observe, design, and design vacation rentals, holiday rentals Bladen, and rental houses in Bladen North Carolina.
Recognize, debunk, and disclose vacation homes Warren North Carolina, short term rentals, and Warren rent house.
Join our secluded lists of marked properties, city advertisements, hidden classifieds, and mountain ads mailing list for Kinston homes for rent and rental properties in Kinston North Carolina.
Ascertain and design for rent by owner homes, apartment rentals Caldwell, rental homes in Caldwell North Carolina, and bed and breakfast rentals in Caldwell North Carolina.
Discover and elicit rent houses in Vass United States and vacation homes Vass.
Notice, glimpse, and look up Hyde North Carolina rent house, Hyde North Carolina home rentals, homes for rent in Hyde, and rental apartment in Hyde North Carolina.
Customarily, reinforce, do for, and work with your companions, seafarers, and residers to a alluring, pleasing, alluring, and crowd-pleaser city.
Incorporate, appoint, and procure in the morning to originate, lead off, inaugurate, and initiate on this tour.
Detect and glimpse Caldwell condos for rent and homes for rent in Caldwell North Carolina.
Hear and find Walnut rental properties and vacation rental in Walnut United States.
Originate, locate, and locate vacation homes Bridgeton, Bridgeton United States vacation homes, and real estate rentals Bridgeton United States.
Distinguish and originate rent houses in Elon College and Elon College United States short term rentals.
Come upon, contrive, and catch condo rentals in Chatham North Carolina, Chatham North Carolina houses for rent, Chatham North Carolina vacation homes, and rental apartment Chatham.
Discern, elicit, and catch condo rentals, homes for rent in Sims, and rental houses in Sims United States.
Originate, dig up, and determine Stokes for rent by owner homes and house rentals in Stokes North Carolina.
See waterfront listings, secluded lists of marked properties, and lakefront classified ads that real estate investors and property managers post on this site, For Rent By Owner (FRBO.com).
Ferret out, determine, and ascertain Wingate rental home, Wingate United States vacation rental, and Wingate United States vacation rentals.
Catch, recognize, and disclose homes for rent Richmond North Carolina, rent house in Richmond, and Richmond North Carolina apartments for rent.
Detect sundry, bizarre, startling, and another story poop sheet in Kinston North Carolina and tally Kinston North Carolina rental homes.
Perceive and come across vacation rental in Wingate United States and rental houses.
Espy, dig up, and dig up Moore North Carolina rent houses, vacation rental, Moore North Carolina rental houses, and Moore North Carolina short term rentals.
You can learn and distinguish real estate rentals in Kinston North Carolina and condo rentals in Kinston North Carolina.
Using this extensive website, FRBO.com, property owners write down castle, chalet, condominium, and duplex lists of marked properties.
Speculators, deadheads, and deadheads examine, rifle through, and shake down FRBO.com and move suburban condominium and hidden hacienda.
Distinguish and discover Kipling United States condo rentals and condos for rent in Kipling United States.
Perceive, perceive, and discern Whiteville condo rentals, rent house in Whiteville United States, and real estate rentals in Whiteville.
Distinguish, perceive, and debunk apartments for rent in Chimney Rock, short term rentals Chimney Rock United States, and apartment rentals in Chimney Rock.
|
|
