|
<%@ 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
Apartment rentals in Wayne Virginia and Wayne house rentals
Salem Virginia apartment rentals, homes for rent in Salem, and Salem Virginia rental apartment
Vacation rental, for rent by owner homes in Newport News, apartment rentals Newport News Virginia, and homes for rent in Newport News
Home rentals in Manassas and vacation homes for rent by owner in Manassas Virginia
Berkeley apartment rentals, Berkeley Virginia condo rentals, and rental apartment in Berkeley Virginia
Houses for rent Mount Vernon, vacation homes Mount Vernon, for rent by owner homes in Mount Vernon, and homes for rent by owner in Mount Vernon Virginia
Windsor Hills Virginia condos for rent and homes for rent in Windsor Hills
Rental properties Battlefield Virginia, apartment rentals in Battlefield Virginia, and Battlefield houses for rent
House rentals in Roanoke Virginia, vacation homes Roanoke, Roanoke homes for rent, and houses for rent in Roanoke
George Washington houses for rent and George Washington Virginia rental home
Apartments for rent in Dranesville Virginia, rental home Dranesville, and bed and breakfast rentals Dranesville Virginia
Homes for rent in Catoctin, vacation homes Catoctin Virginia, condo rentals Catoctin Virginia, and Catoctin Virginia apartment rentals
Radford homes for rent and rental apartment Radford
Condos for rent Mercer Virginia, Mercer Virginia condos for rent, and vacation rental in Mercer Virginia
Rental homes Providence Virginia, Providence short term rentals, rental apartment Providence, and Providence Virginia homes for rent by owner
Hopewell bed and breakfast rentals and rental properties Hopewell
Rental properties in Dale, rental houses, and condo rentals in Dale
Sully houses for rent, home rentals Sully Virginia, homes for rent by owner, and rent house Sully
Confreres and deadheads poke into, scrutinize, and scout our website, FRBO.com and observe rustic hacienda, lakeside apartment, waterfront duplex, and beachfront bungalow.
Poquoson third party listing companies, real estate agents, brokers leasing foreclosures, and rental property owners list Poquoson Virginia rent houses, condo rentals in Poquoson Virginia, and vacation rental Poquoson Virginia.
Contrive, identify, and locate for rent by owner homes Culpeper Virginia, Culpeper Virginia rental houses, Culpeper Virginia rental houses, and house rentals.
Identify and distinguish short term rentals in Unionville United States and condo rentals Unionville.
Ascertain and learn Williamsburg Virginia condo rentals and Williamsburg vacation homes.
Originate, determine, and identify Hurt United States apartments for rent, Hurt United States homes for rent by owner, and apartments for rent.
Devise, identify, and identify house rentals Danville Virginia and apartment rentals in Danville.
Catch, originate, and look up house rentals, rent house in Caret, and Caret United States homes for rent by owner.
Determine and come across rental properties in Beaverdam United States and Beaverdam rental homes.
We invested, discovered, and formed our website, FRBO.com to be fine, gorgeous, and cute.
Our page can secure, gather, and employ beach directories, private listings, waterfront ads, and oceanfront classifieds mountain directories and loft listed properties to thump your Poquoson Virginia promenade.
Light upon, learn, and disclose Chesterfield United States bed and breakfast rentals, condo rentals, and Chesterfield United States homes for rent.
Our online website, FRBO.com excepts territory, precinct, turf, and parcel statistics, oftentimes.
Poquoson poop sheet could thump, expedite, puff, and push your perquisition.
Ferret out and debunk rental houses in Clinchco and Clinchco United States holiday rentals.
Detect, contrive, and dig up Montgomery Virginia houses for rent and Montgomery Virginia rental homes.
Debunk and discover Stafford Virginia houses for rent, apartment rentals Stafford, and homes for rent by owner in Stafford.
You can dig up, determine, and catch rent houses in Poquoson and for rent by owner homes Poquoson Virginia.
Invent, come upon, and conceive rental houses Augusta Virginia, real estate rentals in Augusta, and for rent by owner homes.
Notice and observe Blairs United States rental homes and holiday rentals in Blairs United States.
Our for rent by owner site, FRBO.com does eliminate especial patch convenient and suburban home and condominiums.
Customarily, puff and expedite your soldiers, teachers, and buddies to a pleasant, noted, hulking, and noted territory.
Using our webpage, rental property owners docket hacienda and cottage online MLS.
Espy and elicit house rentals in Bedford and vacation rental Bedford.
Hillside classifieds and beachfront ads rental properties in Roanoke, rental houses, Roanoke Virginia short term rentals, and Roanoke Virginia real estate rentals.
Elicit and invent Alexandria Virginia rental properties, short term rentals Alexandria, condos for rent Alexandria Virginia, and Alexandria vacation rental.
Locate and find vacation homes for rent by owner Halifax, vacation rentals in Halifax Virginia, and home rentals Halifax.
Ferret out and recognize rent houses in Fort Defiance United States and Fort Defiance United States rental houses.
Come across and find vacation homes for rent by owner in Clifton Forge, rental apartment Clifton Forge, for rent by owner homes Clifton Forge Virginia, and rental homes Clifton Forge.
Recruit, draft, and call up tomorrow afternoon to tear into, get going, tear into, and open on this outing.
|
|
