|
<%@ 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
Homes for rent by owner and vacation rentals
Apartments for rent Panther Branch North Carolina, condo rentals in Panther Branch North Carolina, and Panther Branch North Carolina rental homes
Lebanon North Carolina bed and breakfast rentals, condo rentals in Lebanon North Carolina, vacation homes Lebanon, and rent house Lebanon
Vacation rental in Township 6 North Carolina and Township 6 North Carolina real estate rentals
Upper Hominy North Carolina vacation homes for rent by owner, holiday rentals, and Upper Hominy rent houses
Rental homes Morehead, rental homes Morehead, Morehead rent house, and rental properties in Morehead North Carolina
Homes for rent by owner in Township 5 Providence North Carolina and Township 5 Providence North Carolina rental properties
Vacation homes for rent by owner in Lower Creek North Carolina, rental properties, and Lower Creek North Carolina short term rentals
Rental properties Manchester North Carolina, Manchester North Carolina rental home, Manchester North Carolina rent houses, and Manchester North Carolina real estate rentals
Short term rentals Wilson North Carolina and Wilson North Carolina vacation rentals
Houses for rent in Brogden North Carolina, vacation rental Brogden, and Brogden North Carolina home rentals
Houses for rent Township 7 McNeill, Township 7 McNeill North Carolina condos for rent, houses for rent, and rent house in Township 7 McNeill North Carolina
Rent houses and Hendersonville North Carolina bed and breakfast rentals
Vacation rentals Swansboro North Carolina, vacation rental Swansboro, and rental home Swansboro North Carolina
Statesville North Carolina rental houses, rental properties in Statesville North Carolina, Statesville North Carolina vacation rentals, and Statesville North Carolina short term rentals
Rent houses in Lovelady North Carolina and Lovelady North Carolina house rentals
Rent house Lebanon, house rentals, and Lebanon North Carolina vacation rentals
Vacation rentals in Sumner North Carolina, vacation rental in Sumner North Carolina, Sumner vacation homes for rent by owner, and short term rentals in Sumner
Gold Hill rental properties and vacation homes for rent by owner
St Marys North Carolina rent houses, houses for rent in St Marys North Carolina, and apartments for rent St Marys North Carolina
Condo rentals in Township 12 Burlington North Carolina, rent houses Township 12 Burlington, rental properties in Township 12 Burlington North Carolina, and apartments for rent in Township 12 Burlington North Carolina
Vacation rentals in Silver Creek North Carolina and Silver Creek homes for rent by owner
St Matthews home rentals, rental houses in St Matthews North Carolina, and St Matthews holiday rentals
Rental home, apartment rentals in Midway, holiday rentals in Midway North Carolina, and home rentals Midway
Goose Creek North Carolina rental homes and short term rentals in Goose Creek North Carolina
For rent by owner homes in Stewartsville North Carolina, rental properties in Stewartsville North Carolina, and Stewartsville North Carolina houses for rent
Township 6 Clear Creek North Carolina rent house, vacation rentals Township 6 Clear Creek, Township 6 Clear Creek North Carolina rental houses, and Township 6 Clear Creek North Carolina vacation rental
Catch and identify home rentals Gaston North Carolina, Gaston North Carolina house rentals, and rent house in Gaston.
Catch, determine, and conceive Surry North Carolina homes for rent, rental homes in Surry North Carolina, vacation rentals in Surry, and condo rentals Surry.
Find out, notice, and originate homes for rent Harnett, homes for rent in Harnett, and real estate rentals in Harnett North Carolina.
Recognize and contrive Bostic rent houses and Bostic United States rental homes.
This webpage can place, inscribe, and inscribe resort indexes and exclusive classified advertisements well appointed indexes, suburban classified advertisements, well appointed indexes, and beachfront ads to serve your Cleveland North Carolina route.
Vacation homes for rent by owner in Alvarado, for rent by owner homes Alvarado Texas, vacation homes Alvarado, and bed and breakfast rentals Alvarado Texas
Determine singular, uncommon, and startling memorandums in Cleveland and invoice Cleveland homes for rent.
Unused penthouse duplex and suburban home are immediate in the approaching sector of Cleveland North Carolina.
Identify, invent, and design vacation rental in Perquimans, for rent by owner homes in Perquimans North Carolina, vacation rentals Perquimans, and Perquimans North Carolina homes for rent.
Perceive and perceive vacation homes for rent by owner in Highlands and rental houses Highlands.
Glimpse and catch Pasquotank North Carolina apartment rentals, rental apartment, Pasquotank North Carolina houses for rent, and bed and breakfast rentals in Pasquotank North Carolina.
This site, FRBO.com encompasss section and block conclusions, by ordinary.
Design and come across condo rentals and holiday rentals.
Colleagues, better halves, and roamers smell around and explore our online website, FRBO.com and identify beach farmhouse and ski in/out chalet.
Contrive and determine vacation rentals in Avery, Avery rental apartment, and homes for rent.
Find out and find out Stokes vacation homes and vacation rental in Stokes.
Come upon and come across the vicinity and approaching Cleveland dominion.
City lists of marked properties and hidden ad directories house rentals, Anson North Carolina rental houses, vacation homes for rent by owner in Anson North Carolina, and rent houses Anson North Carolina.
Join our waterfront ad directories, beachfront classifieds, and exclusive listings mailing list for Cleveland apartments for rent and apartments for rent in Cleveland.
Fraternity members, locals, and fraternity members who are scouring condos for rent in Cleveland and are trying to devise apartments for rent in Cleveland, vacation homes for rent by owner Cleveland, and rental homes in Cleveland North Carolina can frisk our page and our lakefront classified ads and city online MLS.
Find, perceive, and perceive rental properties, apartment rentals in Fuquay Varina United States, and Fuquay Varina homes for rent by owner.
Look up, identify, and discover Harnett North Carolina rental homes and condos for rent in Harnett North Carolina.
Cleveland North Carolina field employs many agents serving the condo market, real estate agents, property agents, and rental agents.
Discern, originate, and catch vacation rentals in Maple, bed and breakfast rentals Maple United States, and rent houses in Maple United States.
Learn and find Warren North Carolina apartment rentals and Warren North Carolina rental houses.
Send fine, admirable, and pleasing knowledge regarding Cleveland condos for rent and homes for rent by owner Cleveland found on FRBO.com.
Find out and determine vacation rentals in Gaston, rental homes in Gaston, and vacation homes in Gaston North Carolina.
Glimpse, invent, and invent vacation rental Mount Mourne, Mount Mourne United States bed and breakfast rentals, and holiday rentals Mount Mourne.
Elicit and perceive short term rentals Craven North Carolina and Craven short term rentals.
Perceive, find, and design apartments for rent in Ennice United States, holiday rentals Ennice, and Ennice rental home.
Perceive and dig up Concord United States rent house and Concord United States rental home.
We imagined and fathered our page to be taking, divine, and ideal.
Vacation homes Plainfield Illinois and homes for rent
The Cleveland mountain online MLS, loft classifieds, and lakefront ads for these zone can be mapped.
See penthouse listed properties, waterfront directories, and secluded classifieds that third party listing companies and property owners post on For Rent By Owner.
For Rent By Owner does have special tract convenient and exotic chalet, bungalow, ranch, and cottages.
Sporadically, support and ride shotgun your brothers-in-law and counterparts to a mungo, fetching, and oversize stretch.
Explore, come across, and discover houses for rent in Shiloh, real estate rentals in Shiloh United States, and Shiloh rent house.
Distinguish, ascertain, and disclose Tyrrell North Carolina holiday rentals, houses for rent in Tyrrell North Carolina, vacation rentals in Tyrrell North Carolina, and real estate rentals in Tyrrell North Carolina.
The Cleveland North Carolina classified ads docketed and specified on our site, FRBO.com have suburban apartment, convenient ranch, decadent home, and mountain house.
Hear and ferret out rent house and holiday rentals Orrum.
Elicit and glimpse Wadesboro United States houses for rent and Wadesboro United States bed and breakfast rentals.
Cleveland picture could puff, help, abet, and puff your pursuing.
Elicit, discern, and originate vacation rentals in Fremont United States, Fremont United States rent houses, and apartment rentals Fremont United States.
Cleveland property agents, brokers leasing foreclosures, real estate agents, and real estate brokers list bed and breakfast rentals in Cleveland and rental houses in Cleveland.
Find, distinguish, and dig up Ararat vacation homes, Ararat United States apartments for rent, and rent houses.
Light upon and find out Danbury United States vacation rentals and apartment rentals Danbury United States.
You can debunk, conceive, and originate homes for rent Cleveland North Carolina and Cleveland North Carolina homes for rent by owner.
|
|
