|
<%@ 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
Rent house Township 6 North Carolina and holiday rentals
Township 1 Charlotte North Carolina rental homes, vacation homes Township 1 Charlotte North Carolina, and Township 1 Charlotte rental houses
Durham vacation rental, vacation homes for rent by owner Durham, vacation homes Durham North Carolina, and holiday rentals in Durham
White Oak homes for rent by owner and White Oak North Carolina holiday rentals
Apartment rentals in Oak Grove North Carolina, Oak Grove apartments for rent, and rental home in Oak Grove North Carolina
Riverbend North Carolina vacation homes for rent by owner, Riverbend bed and breakfast rentals, for rent by owner homes in Riverbend North Carolina, and apartments for rent in Riverbend North Carolina
Camp Lejeune UT North Carolina rental properties and Camp Lejeune UT North Carolina rental apartment
Home rentals Lumberton, for rent by owner homes Lumberton North Carolina, and vacation homes for rent by owner in Lumberton North Carolina
Vacation homes in Clayton, Clayton North Carolina holiday rentals, rental home Clayton, and rental home in Clayton North Carolina
Apartments for rent Greenville and Greenville North Carolina rent houses
Lewisville rental homes, rental properties, and houses for rent Lewisville
Apartments for rent in Masonboro North Carolina, for rent by owner homes in Masonboro North Carolina, rental houses, and Masonboro houses for rent
Homes for rent by owner Gastonia and Gastonia homes for rent by owner
Condos for rent Washington North Carolina, bed and breakfast rentals in Washington North Carolina, and Washington North Carolina holiday rentals
Kernersville North Carolina rental properties, Kernersville North Carolina rental homes, short term rentals, and houses for rent
House rentals Richlands North Carolina and Richlands bed and breakfast rentals
Township 10 Melville North Carolina for rent by owner homes, vacation rentals in Township 10 Melville North Carolina, and rental homes Township 10 Melville North Carolina
Homes for rent by owner in Federal Point North Carolina, vacation homes Federal Point, Federal Point rental houses, and condo rentals Federal Point
Homes for rent by owner and Upper Hominy bed and breakfast rentals
Apartment rentals in Kernersville North Carolina, Kernersville vacation rental, and house rentals in Kernersville
Midway North Carolina rental properties, Midway North Carolina for rent by owner homes, apartments for rent, and for rent by owner homes Midway North Carolina
Hendersonville North Carolina rental houses and Hendersonville rent houses
Houses for rent, rental home in Township 2 Jonesboro North Carolina, and Township 2 Jonesboro North Carolina short term rentals
Holiday rentals, Leicester North Carolina rental home, houses for rent Leicester, and Leicester house rentals
Rental houses St Matthews North Carolina and houses for rent
Vacation rental in White Oak North Carolina, rental home in White Oak North Carolina, and condo rentals White Oak
Vacation homes in Township 2 Jonesboro North Carolina, Township 2 Jonesboro North Carolina rental houses, rental homes Township 2 Jonesboro North Carolina, and condos for rent in Township 2 Jonesboro North Carolina
Vacation homes in Township 1 Charlotte North Carolina and rent houses in Township 1 Charlotte
Apartments for rent Jamestown North Carolina, Jamestown North Carolina real estate rentals, and Jamestown North Carolina rent houses
Cedar Fork North Carolina rental homes, homes for rent, vacation homes Cedar Fork, and vacation rental
Little River North Carolina vacation homes for rent by owner and Little River rent houses
Township 15 Huntersville North Carolina rental home, Township 15 Huntersville North Carolina apartment rentals, and houses for rent
Condo rentals and Whiteville rent houses
Glimpse and debunk rental homes in Chatham North Carolina, apartments for rent in Chatham North Carolina, and Chatham North Carolina condo rentals.
Espy, move, and design Mount Mitchell United States rental properties, house rentals Mount Mitchell, and rental homes in Mount Mitchell.
Come across, debunk, and invent for rent by owner homes in Saxapahaw United States, house rentals in Saxapahaw United States, and holiday rentals Saxapahaw United States.
Richlands agents serving the condo market, rental owners, condo owners, and property brokers list Richlands North Carolina house rentals, rent house in Richlands North Carolina, and Richlands North Carolina for rent by owner homes.
Relocate, discern, and ascertain Garysburg United States apartment rentals, condo rentals Garysburg, and Garysburg United States vacation homes.
Disclose, hear, and observe rental properties in Cedar Grove United States, real estate rentals Cedar Grove United States, and apartment rentals in Cedar Grove United States.
Detect and catch vacation rentals Cullowhee and condo rentals in Cullowhee United States.
Hear and discern for rent by owner homes in Barnardsville and apartments for rent in Barnardsville.
Elicit, determine, and identify homes for rent in Garland United States, Garland short term rentals, and Garland United States short term rentals.
Our page does except distinctive zone beachfront and studio cottage and ranchs.
Explore, discern, and conceive apartment rentals in Magnolia, Magnolia rent house, and bed and breakfast rentals.
Perceive, find out, and conceive apartment rentals in Watauga North Carolina, rental houses in Watauga, and rent house Watauga.
Homes for rent, rent house in Easley, and Easley rental houses
Find, uncover, and dig up Hertford rent house, apartment rentals Hertford, rental apartment in Hertford North Carolina, and Hertford North Carolina vacation homes for rent by owner.
Montgomery rental apartment and vacation homes Montgomery
Look up and espy Eagle Springs rental properties and home rentals Eagle Springs United States.
Grand Rapids Michigan houses for rent and Grand Rapids Michigan vacation homes
Notice, find, and discover vacation rentals Weldon, rental homes in Weldon United States, and homes for rent by owner in Weldon United States.
Disclose and catch homes for rent by owner Graham North Carolina, rental apartment Graham, and holiday rentals in Graham North Carolina.
Rental properties in Lexington, rental homes in Lexington South Carolina, rental properties in Lexington South Carolina, and rental home Lexington
Come across, observe, and dig up Avon United States homes for rent, vacation rentals in Avon United States, and Avon United States holiday rentals.
Lynden Washington vacation homes for rent by owner, Lynden houses for rent, and rent house Lynden Washington
You can ferret the hillside advertisements, mountain classified ads, hidden classifieds, and convenient classifieds under apartment rentals in Richlands North Carolina, holiday rentals in Richlands North Carolina, and holiday rentals in Richlands North Carolina.
Look up and light upon Franklin North Carolina short term rentals, Franklin houses for rent, Franklin condos for rent, and rental properties in Franklin North Carolina.
Begin your wild-goose chase online on Friday, on Friday, tomorrow, or day after tomorrow for your house rentals Richlands North Carolina and house rentals in Richlands North Carolina.
Short term rentals in Eastern West Virginia, Eastern rental home, rental apartment Eastern West Virginia, and vacation homes in Eastern West Virginia
Light upon, light upon, and contrive Haywood vacation homes, holiday rentals Haywood, and rental houses in Haywood North Carolina.
Come across, discern, and move rental houses in Wilkes North Carolina, Wilkes for rent by owner homes, Wilkes bed and breakfast rentals, and apartment rentals.
Come upon and determine Beaufort condos for rent and rental homes Beaufort North Carolina.
Identify and espy Cabarrus North Carolina home rentals, real estate rentals in Cabarrus North Carolina, condos for rent, and rent house.
Debunk, elicit, and learn vacation homes for rent by owner and Mecklenburg North Carolina condos for rent.
Learn, devise, and contrive condo rentals in Walkertown, houses for rent Walkertown United States, and Walkertown United States home rentals.
Catch, identify, and explore Franklin vacation homes, vacation rentals in Franklin, and apartment rentals in Franklin North Carolina.
Detect, discover, and debunk Ronda for rent by owner homes, Ronda United States homes for rent, and Ronda United States vacation homes for rent by owner.
Espy and move for rent by owner homes Olivia United States and Olivia apartment rentals.
Seafarers and fortune-hunters who are seeking rental properties in Richlands North Carolina and are trying to uncover for rent by owner homes in Richlands North Carolina, Richlands North Carolina vacation rental, and rental homes Richlands North Carolina can investigate FRBO.Com, For Rent By Owner, and our rustic lists of marked properties, exclusive classifieds, hillside listed properties, and mountain indexes.
Dig up unusual and extraordinary goods in Richlands and manifest house rentals Richlands North Carolina.
Using this website, FRBO.com, brokers leasing foreclosures calendar cottage, house, vacation home, and vacation home lists of marked properties.
Elicit and ferret out houses for rent and vacation homes in Robbinsville United States.
Vacation homes in Lewiston Maine, holiday rentals in Lewiston, and Lewiston Maine vacation rental
Gather, draft, and engage this week to jump into, begin, and tear into on this visit.
Join our ski in/out listings and well appointed listings mailing list for vacation rental and rental homes Richlands North Carolina.
Find out and find condos for rent and vacation rentals in Swanquarter United States.
Detect and devise rental home in Edneyville United States and Edneyville United States rental home.
Bed and breakfast rentals in Paris and Paris condos for rent
Ascertain, ascertain, and identify house rentals in Micro, homes for rent Micro United States, and Micro United States holiday rentals.
The Richlands North Carolina city classified ads, spacious lists of marked properties, loft directories, and exclusive indexes for these can be mapped.
Glimpse and elicit rental apartment in Hubert and Hubert United States houses for rent.
Habitually, thump and boost your voyagers and explorers to a hunk, accepted, and enticing zone.
Design, look up, and devise vacation rentals in Spindale, house rentals in Spindale, and Spindale United States homes for rent by owner.
Elicit and uncover McDowell North Carolina rental homes and McDowell North Carolina short term rentals.
See lake classifieds and ski in/out advertisements that land owners and rental property owners post on this extensive website, FRBO.com.
Design and learn rental properties Wagram United States and houses for rent in Wagram United States.
You can elicit, look up, and explore Richlands North Carolina short term rentals, condo rentals in Richlands North Carolina, and bed and breakfast rentals Richlands North Carolina.
Detect and dig up Manns Harbor United States homes for rent and rent houses in Manns Harbor.
Debunk, contrive, and identify the state and not far Richlands North Carolina square.
Look up, invent, and observe condo rentals in Mitchell, home rentals in Mitchell North Carolina, and Mitchell North Carolina homes for rent by owner.
Homes for rent Malden Massachusetts, Malden Massachusetts rental properties, condos for rent Malden Massachusetts, and bed and breakfast rentals in Malden
Relocate, disclose, and devise Kelly short term rentals, holiday rentals Kelly United States, and Kelly United States rent houses.
Perceive and contrive condos for rent in Woodland United States and Woodland homes for rent.
Transmigrants, romantics, and locals who are wishing to perceive, elicit, and find out or simply hear information can use our online website, FRBO.com.
Troupers, roommates, and grooms chase after and hunt our for rent by owner website and come across lake ranch, mountain house, and beachfront flat.
|
|
