|
<%@ 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" %>
|
Virginia Rental Links
Rental homes in Rock Hill and house rentals in Rock Hill Virginia
Houses for rent in Cold Harbor Virginia, condos for rent in Cold Harbor Virginia, and Cold Harbor Virginia bed and breakfast rentals
Home rentals Beaverdam Virginia, holiday rentals in Beaverdam, Beaverdam rental apartment, and Beaverdam Virginia rental homes
Rent house and rental houses in Hopewell Virginia
Rental properties, homes for rent Brookland Virginia, and rent houses in Brookland Virginia
Vacation rentals Waynesboro, condos for rent in Waynesboro Virginia, homes for rent, and for rent by owner homes in Waynesboro Virginia
Blue Ridge Virginia rental properties and apartments for rent in Blue Ridge Virginia
For rent by owner homes in Lebanon Virginia, Lebanon Virginia homes for rent, and home rentals
Vacation homes in Catawba Virginia, homes for rent by owner in Catawba Virginia, apartments for rent in Catawba Virginia, and Catawba condos for rent
Real estate rentals in Ashby Virginia and homes for rent Ashby
Blue Ridge Virginia rental houses, vacation rentals, and vacation rental
Rent houses Hollins, house rentals, condo rentals Hollins Virginia, and Hollins Virginia rental home
Mason homes for rent by owner and vacation homes for rent by owner Mason Virginia
Vacation homes in Alexandria Virginia, apartment rentals in Alexandria, and Alexandria Virginia rent houses
Scottsville Virginia homes for rent by owner, homes for rent by owner in Scottsville, Scottsville Virginia vacation homes, and house rentals in Scottsville Virginia
House rentals Sully Virginia and house rentals in Sully Virginia
Rental home in Hampton Virginia, apartment rentals in Hampton, and condos for rent Hampton Virginia
Apartments for rent in Berkeley Virginia, holiday rentals Berkeley Virginia, holiday rentals in Berkeley Virginia, and real estate rentals in Berkeley Virginia
For rent by owner homes in Petersburg Virginia and Petersburg Virginia apartment rentals
Vacation rental, bed and breakfast rentals, and apartments for rent Gainesboro
For rent by owner homes in Dulles Virginia, vacation rentals in Dulles Virginia, rental home in Dulles Virginia, and homes for rent by owner in Dulles Virginia
Bed and breakfast rentals in Hampton Virginia and homes for rent
Vacation homes for rent by owner in Mercer, vacation homes for rent by owner, and Mercer Virginia condo rentals
Home rentals, rental home in Brentsville Virginia, Brentsville Virginia apartments for rent, and Brentsville Virginia rental homes
Varina Virginia houses for rent and rent house Varina Virginia
Recognize other, various, novel, and distinct notes in Central Virginia and docket condos for rent Central Virginia.
See studio directories, lakefront online MLS, well appointed indexes, and city directories that property owners and property agents post on FRBO.com.
Identify, come upon, and debunk Rochelle United States for rent by owner homes, rental properties in Rochelle United States, and Rochelle United States condo rentals.
The Central Virginia hillside indexes, studio classifieds, beachfront listings, and well appointed online MLS for these can be mapped.
Uncover and contrive condos for rent and homes for rent by owner in Hood United States.
Sometimes, work for and serve your better halves, grooms, and residents to a mungo and roomy area.
Begin your fishing expedition online in the morning or tonight for your vacation homes in Central Virginia and Central Virginia holiday rentals.
Glimpse and come across Craig Virginia condos for rent, Craig Virginia real estate rentals, homes for rent by owner in Craig Virginia, and bed and breakfast rentals in Craig.
Dig up and ferret out vacation homes Burkes Garden and Burkes Garden United States condo rentals.
Distinguish, uncover, and explore Warsaw vacation rentals, rental home in Warsaw, and vacation rentals.
Detect and relocate real estate rentals in White Post United States and house rentals in White Post United States.
Pre-rented beach house, lake cottage, and city bungalow are not remote in the imminent city of Central Virginia.
Contrive and elicit homes for rent by owner in Franklin, Franklin short term rentals, Franklin Virginia rent houses, and Franklin Virginia rental homes.
Come across, identify, and discover short term rentals in Wicomico United States, holiday rentals, and rental homes in Wicomico.
Perceive and elicit rental homes Emory and Emory United States rent houses.
The Central ad directories run down and docketed on our for rent by owner site, FRBO.com accommodate rustic farmhouse, exclusive cabin, lake hacienda, and decadent ranch.
You can glimpse, identify, and catch home rentals, rent house in Central Virginia, and Central rent house.
Observe and catch real estate rentals, apartment rentals Bath Virginia, and Bath Virginia rent houses.
Join our studio classified ads and penthouse ads mailing list for Central Virginia rental houses and rental homes Central.
Record, sign on, and employ day after tomorrow to initiate and launch on this route.
Conceive, devise, and dig up King William Virginia condo rentals, vacation rental in King William Virginia, and King William Virginia rental houses.
Short term rentals, Central Kent Delaware house rentals, apartments for rent Central Kent Delaware, and vacation rentals in Central Kent Delaware
Catch and relocate rental home Buckingham Virginia, vacation rentals Buckingham Virginia, and condos for rent in Buckingham Virginia.
Find out, find out, and devise Bland Virginia real estate rentals, for rent by owner homes in Bland Virginia, for rent by owner homes in Bland, and apartments for rent Bland.
Contrive, learn, and perceive home rentals in Valentines United States, condo rentals in Valentines United States, and Valentines vacation rental.
Relocate, dig up, and design vacation homes Naruna United States, homes for rent Naruna United States, and vacation rentals Naruna.
Discover and identify Roanoke Virginia vacation homes for rent by owner and homes for rent by owner in Roanoke Virginia.
West Tom Green vacation homes for rent by owner and West Tom Green vacation rental
Ascertain and identify Leon rental apartment and Leon United States vacation rentals.
Perceive and devise Honaker condos for rent and condo rentals in Honaker United States.
Our online website, FRBO.com does embrace specialized spacious, spacious, rustic, and mountain bungalow, hacienda, and villas.
Central Virginia zone employs many home owners, property brokers, home owners, and third party agents.
City listed properties and suburban lists of marked properties condos for rent in Colonial Heights Virginia, apartment rentals in Colonial Heights Virginia, Colonial Heights real estate rentals, and rent house in Colonial Heights Virginia.
Find and look up condos for rent in Nuttsville and holiday rentals in Nuttsville United States.
Uncover, recognize, and observe Indian Valley United States vacation homes for rent by owner, Indian Valley vacation rentals, and Indian Valley United States vacation homes for rent by owner.
Locate, perceive, and originate Montgomery Virginia house rentals, apartments for rent in Montgomery Virginia, rental apartment in Montgomery Virginia, and Montgomery rental properties.
|
|
