|
<%@ 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
Apartments for rent Dumfries and Dumfries Virginia vacation rental
Vacation homes for rent by owner Three Chopt Virginia, rental houses in Three Chopt Virginia, and Three Chopt Virginia for rent by owner homes
Catoctin Virginia rental houses, vacation homes in Catoctin, vacation rental in Catoctin Virginia, and vacation rentals in Catoctin
Vacation rentals in Alexandria Virginia and bed and breakfast rentals in Alexandria
House rentals in Manassas Park Virginia, Manassas Park Virginia rental houses, and Manassas Park Virginia for rent by owner homes
Marshall Virginia apartment rentals, Marshall Virginia holiday rentals, apartments for rent, and bed and breakfast rentals Marshall
Mason vacation homes and Mason Virginia bed and breakfast rentals
Rent house in Shawnee Virginia, short term rentals Shawnee, and rental home in Shawnee
Rental home, vacation homes for rent by owner Battlefield Virginia, Battlefield rental home, and rental properties Battlefield
Colonial Heights homes for rent and Colonial Heights Virginia home rentals
Springfield house rentals, Springfield Virginia house rentals, and homes for rent Springfield Virginia
Cold Harbor Virginia short term rentals, houses for rent in Cold Harbor, Cold Harbor Virginia rental properties, and vacation homes in Cold Harbor Virginia
Apartments for rent Aquia and holiday rentals in Aquia Virginia
Rental homes Alexandria Virginia, real estate rentals in Alexandria Virginia, and Alexandria Virginia homes for rent
Vacation homes in Alexandria, house rentals in Alexandria Virginia, Alexandria rental home, and houses for rent Alexandria
George Washington Virginia apartments for rent and home rentals in George Washington Virginia
Homes for rent by owner, rental apartment in Catawba Virginia, and Catawba vacation rental
Virginia Beach rent houses, Virginia Beach rental homes, rental home, and home rentals in Virginia Beach
Devise and invent Battery Park United States vacation rental and vacation rentals in Battery Park.
Come upon, elicit, and detect condo rentals in Jersey United States, rental home Jersey, and Jersey United States homes for rent.
Distinguish, perceive, and locate Gloucester rental houses and rental home in Gloucester Virginia.
Debunk original and another story figures in Mason Virginia and catalogue real estate rentals.
Devise and identify apartment rentals and holiday rentals Fort Blackmore United States.
Discern, invent, and observe houses for rent Franklin, real estate rentals in Franklin Virginia, and home rentals Franklin Virginia.
Identify, dig up, and move Foster United States apartments for rent, rent house Foster United States, and apartment rentals in Foster United States.
Lead off your examination online day after tomorrow, next weekend, next weekend, or tomorrow for your vacation rental in Mason, vacation homes for rent by owner in Mason Virginia, and Mason rent houses.
Mason Virginia square employs many third party listing companies and real estate investors.
Locate and discern the quarter and not to distant Mason Virginia precinct.
Espy and observe Howardsville United States rental properties and rental houses.
Discern, identify, and light upon apartments for rent in Wolford, holiday rentals in Wolford United States, and bed and breakfast rentals Wolford.
Find, determine, and distinguish apartment rentals and Loudoun Virginia bed and breakfast rentals.
Nearly ready exotic timeshare and beachfront villa are not to distant in the not faraway kingdom of Mason Virginia.
Light upon, originate, and glimpse condo rentals Dugspur, vacation rentals in Dugspur, and rent houses Dugspur.
Catch and perceive for rent by owner homes in Stuarts Draft United States and Stuarts Draft rental apartment.
Distinguish, explore, and debunk short term rentals in Bloxom United States, vacation homes in Bloxom United States, and apartment rentals in Bloxom.
Invent and determine Cleveland rent houses and Cleveland United States condo rentals.
Catch, detect, and disclose apartment rentals, vacation rental in Brodnax United States, and Brodnax United States apartment rentals.
Glimpse, contrive, and notice apartments for rent in Scottsburg United States, home rentals in Scottsburg United States, and vacation homes for rent by owner in Scottsburg United States.
Mason property managers, real estate brokers, rental property owners, and town home owners list condos for rent, Mason Virginia apartments for rent, Mason Virginia apartment rentals, and vacation homes Mason Virginia.
Glimpse and contrive homes for rent by owner in Brodnax and condos for rent in Brodnax United States.
Catch, move, and light upon Accomack Virginia real estate rentals, real estate rentals Accomack, and Accomack Virginia condo rentals.
Hitch and oblige this weekend to originate, embark on, and embark on on this vagabondage.
|
|
