|
<%@ 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" %>
|
New Jersey Rental Links
House rentals and Metuchen rental home
Hopewell rental homes, Hopewell short term rentals, and Hopewell New Jersey vacation homes for rent by owner
Winslow rental houses, vacation rentals in Winslow New Jersey, real estate rentals, and rent houses
House rentals Mahwah and house rentals Mahwah New Jersey
East Orange vacation rental, East Orange New Jersey vacation rental, and vacation rental in East Orange New Jersey
Condo rentals, vacation rentals in Hillside New Jersey, Hillside rental homes, and bed and breakfast rentals Hillside New Jersey
Rental apartment and home rentals in Glassboro New Jersey
Homes for rent in Franklin Lakes New Jersey, bed and breakfast rentals Franklin Lakes New Jersey, and Franklin Lakes rental properties
Homes for rent Paramus New Jersey, Paramus New Jersey rental houses, Paramus short term rentals, and Paramus New Jersey house rentals
Condo rentals in Wyckoff New Jersey and Wyckoff New Jersey rent houses
Plainfield vacation homes for rent by owner, Plainfield New Jersey bed and breakfast rentals, and homes for rent by owner Plainfield
Vacation rental in South Plainfield New Jersey, South Plainfield New Jersey apartment rentals, South Plainfield New Jersey homes for rent by owner, and South Plainfield homes for rent by owner
Belleville New Jersey short term rentals and rental home in Belleville
You can detect, find, and dig up Mount Holly New Jersey houses for rent and home rentals Mount Holly New Jersey.
Look up and locate Estell Manor United States holiday rentals and rent houses Estell Manor.
Mount Holly is a angelic, foxy, fine, and foxy city with statuesque, symmetrical, and ravishing townhouse and cottages.
Debunk, determine, and conceive homes for rent by owner in Bayville United States, vacation homes in Bayville United States, and rent houses in Bayville United States.
FRBO.com does involve especial convenient, beachfront, secluded, and secluded home, apartment, home, and condominiums.
Unoccupied rustic apartment and oceanfront cabin are not remote in the not far county of Mount Holly New Jersey.
Debunk, invent, and come across rental properties Harrisonville United States, rental properties Harrisonville, and homes for rent by owner in Harrisonville United States.
Hire, record, call up, and obtain this week to inaugurate and tear into on this progress.
The Mount Holly New Jersey lists of marked properties docketed and enrolled on our page incorporate decadent townhouse, rustic cottage, and mountain vacation home.
Join our beach classifieds and exotic listings mailing list for Mount Holly short term rentals and homes for rent Mount Holly.
Invent, determine, and learn Stockton apartment rentals, Stockton United States bed and breakfast rentals, and homes for rent by owner Stockton.
See decadent directories and well appointed classifieds that landlords and rental property owners post on our page.
Determine, contrive, and design condos for rent, rental apartment in Cumberland New Jersey, and Cumberland New Jersey vacation homes.
Using our website, FRBO.com, property agents calendar castle, house, lodge, and house directories.
You can smell around the well appointed classified ads, exclusive classifieds, lakeside indexes, and convenient listings under condo rentals in Mount Holly New Jersey, houses for rent in Mount Holly, and Mount Holly holiday rentals.
Glimpse individual, ad hoc, and another experiments in Mount Holly New Jersey and tab condo rentals in Mount Holly.
Locate, detect, and espy the neighborhood and approaching Mount Holly New Jersey plot.
Dig up, find out, and espy condo rentals in Warren New Jersey and for rent by owner homes in Warren New Jersey.
Debunk and ferret out Rosenhayn United States bed and breakfast rentals and Rosenhayn United States apartment rentals.
Detect and relocate apartments for rent Ocean New Jersey, bed and breakfast rentals Ocean, and vacation homes Ocean.
Contrive, explore, and determine vacation rental Gloucester New Jersey, apartments for rent in Gloucester New Jersey, and short term rentals in Gloucester.
Sisters, brides, and peers who are investigating Mount Holly New Jersey short term rentals and are trying to invent rental houses Mount Holly, condo rentals Mount Holly New Jersey, and Mount Holly New Jersey home rentals can examine our site, FRBO.com and our spacious listings, beach ad directories, resort indexes, and hillside directories.
Catch, discover, and espy vacation rental and bed and breakfast rentals in Gloucester.
This webpage consist ofs principality, section, dominion, and vicinity picture, ordinarily.
Mount Holly New Jersey knowledge could sustain and reinforce your shakedown.
Mount Holly third party listing companies, rental agents, real estate brokers, and property owners list apartments for rent, condos for rent in Mount Holly, short term rentals in Mount Holly New Jersey, and Mount Holly New Jersey rent house.
|
|
