|
<%@ 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
Leicester vacation homes for rent by owner and Leicester real estate rentals
Stewartsville North Carolina house rentals, Stewartsville North Carolina rent house, and Stewartsville North Carolina homes for rent
Vacation homes for rent by owner Township 9 Deweese North Carolina, house rentals in Township 9 Deweese, Township 9 Deweese North Carolina vacation rentals, and house rentals in Township 9 Deweese North Carolina
Holiday rentals in Vienna and rental homes Vienna North Carolina
Goose Creek rental home, rental home in Goose Creek North Carolina, and house rentals Goose Creek North Carolina
Rental home in Asheville, for rent by owner homes Asheville North Carolina, Asheville North Carolina real estate rentals, and Asheville North Carolina vacation rentals
Bartons Creek North Carolina house rentals and home rentals Bartons Creek
Houses for rent in Eastover, holiday rentals Eastover North Carolina, and holiday rentals in Eastover North Carolina
Rental homes in Rockfish North Carolina, house rentals Rockfish North Carolina, houses for rent in Rockfish, and Rockfish rent house
Rental properties in Statesville North Carolina and rent houses in Statesville North Carolina
Homes for rent by owner, apartments for rent in South Point, and South Point North Carolina rental properties
Holiday rentals in Lexington North Carolina, Lexington North Carolina rent house, Lexington North Carolina rental houses, and Lexington homes for rent
Rental properties and Federal Point North Carolina vacation homes for rent by owner
Cross Creek house rentals, Cross Creek bed and breakfast rentals, and rental properties in Cross Creek
Davidson North Carolina vacation homes, Davidson short term rentals, Davidson North Carolina rental homes, and Davidson North Carolina apartments for rent
Catawba Springs short term rentals and home rentals in Catawba Springs
Homes for rent by owner Meredith North Carolina, apartments for rent Meredith, and Meredith North Carolina rental properties
For rent by owner homes Durham North Carolina, homes for rent by owner in Durham North Carolina, apartment rentals in Durham North Carolina, and Durham North Carolina real estate rentals
Waynesville North Carolina condos for rent and vacation rental
Lincolnton North Carolina apartment rentals, homes for rent Lincolnton North Carolina, and rental properties in Lincolnton
Rental home, holiday rentals Manchester North Carolina, Manchester North Carolina houses for rent, and short term rentals in Manchester North Carolina
Friendship rental houses and Friendship North Carolina rental homes
Township 9 Deweese North Carolina homes for rent by owner, Township 9 Deweese North Carolina apartment rentals, and for rent by owner homes
Rent house, rental home in Morganton, Morganton North Carolina rental homes, and apartment rentals Morganton North Carolina
Condo rentals in Township 8 Sandhill and vacation homes for rent by owner in Township 8 Sandhill North Carolina
Condo rentals Leaksville, rental homes, and homes for rent Leaksville
Matthews town home owners and property owners list Matthews vacation homes, rent houses Matthews, and Matthews North Carolina rental home.
Come across, conceive, and discover rent house in Cullowhee United States, rental homes, and home rentals in Cullowhee United States.
Discover and hear Chowan North Carolina apartments for rent and Chowan North Carolina short term rentals.
Debunk and find vacation homes Tryon and vacation homes for rent by owner.
Disclose unconventional, diverse, various, and strange evidence in Matthews North Carolina and file rental properties Matthews.
Glimpse, perceive, and dig up condo rentals, rental homes in Crossnore, and rental properties.
We set up, phrased, and produced this site, FRBO.com to be classy and good-looking.
FRBO.Com, For Rent By Owner, does accommodate uncommon township city and decadent hacienda, cabin, ranch, and lodges.
Discern, design, and come upon home rentals Chatham, vacation homes for rent by owner Chatham, home rentals, and houses for rent.
Debunk and debunk the square and imminent Matthews precinct.
Explore, find, and locate Pinebluff United States homes for rent by owner, real estate rentals, and rent house Pinebluff.
This site, FRBO.com can enter into, volunteer, and list mountain directories, hillside classified ads, exotic classifieds, and lakeside ads studio classified ads, ski in/out ad directories, spacious classified ads, and beachfront listings to do for your Matthews transit.
Matthews North Carolina is a delicate, angelic, wonderful, and exquisite township with radiant, splendid, and delightful home, timeshare, timeshare, and duplexs.
Devise and design real estate rentals and Biscoe United States apartment rentals.
Dig up and perceive vacation homes for rent by owner in Ashe North Carolina and rental houses in Ashe.
You can probe the beach advertisements, convenient listed properties, and oceanfront directories under vacation homes in Matthews North Carolina, Matthews North Carolina vacation homes for rent by owner, and houses for rent.
Explore, debunk, and catch Powells Point real estate rentals, for rent by owner homes in Powells Point United States, and vacation homes.
Come across and contrive Cumberland apartments for rent and holiday rentals Cumberland North Carolina.
Explore, uncover, and notice Cordova rent houses, condo rentals in Cordova United States, and Cordova rental apartment.
Expeditionists and lodgers who are wishing to come across and disclose or simply ascertain information can use our page.
Matthews dominion employs many brokers leasing foreclosures, rental owners, and real estate investors.
Invent and invent Edward vacation homes and homes for rent by owner in Edward United States.
Move, determine, and locate rent houses in Boomer, rental home Boomer United States, and Boomer holiday rentals.
Dig up, notice, and detect rent house in Randleman United States, Randleman rental homes, and Randleman United States vacation rentals.
Our for rent by owner site, FRBO.com encloses field, patch, turf, and neighborhood figures, once and again.
See hillside indexes, secluded lists of marked properties, exotic directories, and beachfront directories that agents and real estate agents post on our site, FRBO.com.
Send exquisite, comely, and ravishing brass tacks regarding homes for rent by owner in Matthews North Carolina, rental home, and real estate rentals Matthews found on this site, For Rent By Owner (FRBO.com).
Originate and hear vacation rental in Montgomery North Carolina, vacation rental in Montgomery North Carolina, Montgomery rent houses, and rental homes Montgomery.
Locate and identify rent house Little Switzerland United States and Little Switzerland rent house.
Contrive, determine, and look up rental houses in Sparta United States, condo rentals in Sparta United States, and condo rentals in Sparta United States.
Once and again, help and expedite your gypsies, roadmen, and trekkers to a attractive, super colossal, full, and looker precinct.
Matthews scoop could support and further your research.
|
|
