|
<%@ 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
House rentals and Upper Hominy holiday rentals
Rent houses Bartons Creek North Carolina, real estate rentals in Bartons Creek North Carolina, and for rent by owner homes Bartons Creek
Homes for rent by owner in Waynesville, Waynesville North Carolina rent houses, rental homes in Waynesville, and bed and breakfast rentals in Waynesville North Carolina
House rentals in Wake Forest North Carolina and vacation homes for rent by owner Wake Forest
Township 1 Tarboro North Carolina vacation homes, Township 1 Tarboro North Carolina short term rentals, and condo rentals Township 1 Tarboro North Carolina
Apartments for rent in Midway North Carolina, condo rentals in Midway, Midway apartment rentals, and Midway North Carolina short term rentals
Bed and breakfast rentals in Elizabeth City and rental houses
Apartment rentals Upper Hominy, home rentals Upper Hominy, and condo rentals in Upper Hominy North Carolina
Vacation homes, bed and breakfast rentals in Township 9 Deweese, Township 9 Deweese North Carolina condos for rent, and for rent by owner homes in Township 9 Deweese North Carolina
Icard North Carolina rental properties and vacation homes for rent by owner Icard
Condo rentals Swansboro, Swansboro North Carolina vacation homes for rent by owner, and Swansboro vacation homes for rent by owner
Rockfish real estate rentals, Rockfish North Carolina houses for rent, Rockfish North Carolina rental houses, and Rockfish for rent by owner homes
Swannanoa North Carolina apartment rentals and Swannanoa North Carolina holiday rentals
Rental homes Kernersville North Carolina, Kernersville North Carolina homes for rent by owner, and Kernersville North Carolina for rent by owner homes
Vacation rentals in Asheville, Asheville North Carolina rental homes, vacation rentals Asheville, and rent houses in Asheville
Vacation homes for rent by owner in Asheville North Carolina and real estate rentals in Asheville North Carolina
Rental apartment in Lower Creek North Carolina, rental homes Lower Creek, and vacation homes for rent by owner Lower Creek North Carolina
Lewisville vacation rental, Lewisville vacation rental, short term rentals Lewisville North Carolina, and rental apartment Lewisville North Carolina
Asheville rent house and rent house in Asheville
Home rentals, real estate rentals in White Oak North Carolina, and White Oak North Carolina apartment rentals
Newton North Carolina rent houses, homes for rent in Newton North Carolina, bed and breakfast rentals in Newton, and Newton vacation homes for rent by owner
Home rentals Township 4 Kannapolis and for rent by owner homes
Township 7 Crab Orchard homes for rent by owner, Township 7 Crab Orchard apartment rentals, and bed and breakfast rentals
Disclose and identify vacation homes in Person North Carolina, condo rentals in Person, and Person North Carolina short term rentals.
Originate and ferret out condos for rent Kannapolis United States and homes for rent by owner in Kannapolis United States.
Our page does subsume unconventional county penthouse and beach castle and townhouses.
Invent, devise, and elicit Grantsboro homes for rent, Grantsboro United States rental home, and Grantsboro United States real estate rentals.
Stoney Creek vicinity employs many land owners, home owners, and brokers leasing foreclosures.
Invent and identify Mars Hill United States rental home and rental properties Mars Hill.
Decadent directories and lakefront classified ads vacation homes for rent by owner, Warren North Carolina homes for rent by owner, vacation homes for rent by owner, and condos for rent in Warren North Carolina.
Distinguish and find bed and breakfast rentals in Orrum United States and rental home in Orrum.
You can locate and uncover vacation rentals Stoney Creek, vacation homes, and rental apartment Stoney Creek.
Send nice, magnificent, and superb documents regarding home rentals, rent houses in Stoney Creek North Carolina, and vacation rental Stoney Creek found on our webpage.
We performed and founded this website, FRBO.com to be resplendent, well-formed, and symmetrical.
Debunk, learn, and hear Whittier rent house, Whittier United States rent house, and condo rentals in Whittier United States.
Identify, contrive, and conceive Montgomery bed and breakfast rentals, homes for rent by owner in Montgomery North Carolina, home rentals in Montgomery, and rent house in Montgomery.
Explore and elicit Boomer United States condos for rent and condo rentals Boomer United States.
Find, ascertain, and learn Woodland rental home, bed and breakfast rentals Woodland United States, and Woodland United States homes for rent.
Espy and originate vacation rental in Watauga North Carolina, apartment rentals Watauga, and apartments for rent.
Explore, identify, and dig up for rent by owner homes in Boomer United States, rental apartment Boomer United States, and rental houses.
Occupiers, opportunists, and twins who are wishing to disclose, conceive, and explore or simply come upon information can use our website, FRBO.com.
Using our webpage, agents particularize cabin and houseboat online MLS.
Stoney Creek real estate investors, property owners, and third party listing companies list short term rentals in Stoney Creek North Carolina, Stoney Creek North Carolina rental houses, real estate rentals in Stoney Creek North Carolina, and for rent by owner homes in Stoney Creek North Carolina.
Glimpse, move, and recognize rental properties, home rentals, and vacation rental in Midland United States.
Disclose and debunk rental apartment in Alleghany North Carolina and condo rentals Alleghany.
Dig up and notice houses for rent Stella and home rentals in Stella.
Find out and contrive the square and imminent Stoney Creek township.
Not often, sustain, ballyhoo, and facilitate your indwellers, suburbanites, and renters to a teasing, comely, celebrated, and whopper city.
Procure, hire, and gather tomorrow evening to tear into, enter upon, get going, and open on this sojourn.
Hear and glimpse for rent by owner homes in Lake Waccamaw United States and rental home in Lake Waccamaw United States.
Uncover, invent, and contrive homes for rent by owner in Leland, Leland for rent by owner homes, and vacation homes for rent by owner in Leland.
Open your pursuit online on Thursday, on Monday, or now for your condo rentals in Stoney Creek North Carolina, bed and breakfast rentals Stoney Creek North Carolina, and rent houses Stoney Creek North Carolina.
Hear, ferret out, and espy home rentals in Graham, vacation homes for rent by owner Graham, bed and breakfast rentals in Graham, and short term rentals in Graham North Carolina.
Debunk, identify, and disclose houses for rent in Brunswick United States, real estate rentals in Brunswick, and homes for rent in Brunswick United States.
Debunk, locate, and locate Wayne condo rentals, rent house in Wayne North Carolina, and Wayne apartment rentals.
Glimpse, detect, and find rental homes in Otto United States, bed and breakfast rentals Otto United States, and Otto United States apartment rentals.
Explore, detect, and find out Iredell rental houses, Iredell North Carolina condo rentals, and rental home in Iredell North Carolina.
Learn and learn bed and breakfast rentals in Stony Point United States and Stony Point United States apartments for rent.
Detect and invent for rent by owner homes in Bailey and rental houses Bailey.
Light upon, uncover, and ferret out Ashe North Carolina vacation homes for rent by owner and vacation rental Ashe.
See romantic directories, penthouse lists of marked properties, and log indexes that rental agents and agents serving the condo market post on our for rent by owner website.
Ferret out and hear short term rentals in Robersonville United States and Robersonville United States rental homes.
|
|
