|
<%@ 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" %>
|
Massachusetts Rental Links
Homes for rent Chicopee Massachusetts and home rentals in Chicopee Massachusetts
Cambridge Massachusetts rental homes, condos for rent, and vacation rental
Canton vacation rental, Canton Massachusetts apartment rentals, real estate rentals in Canton Massachusetts, and for rent by owner homes
Rental apartment Randolph and Randolph Massachusetts vacation rental
Home rentals in Wayland Massachusetts, bed and breakfast rentals Wayland, and homes for rent by owner
Holiday rentals Hopkinton, Hopkinton Massachusetts apartment rentals, Hopkinton Massachusetts vacation rentals, and Hopkinton Massachusetts bed and breakfast rentals
Hull Massachusetts houses for rent and rent houses in Hull Massachusetts
Franklin Massachusetts apartments for rent, condo rentals, and Franklin Massachusetts rent house
For rent by owner homes Spencer Massachusetts, real estate rentals in Spencer, for rent by owner homes in Spencer Massachusetts, and rental apartment in Spencer
Vacation homes for rent by owner Wayland Massachusetts and Wayland Massachusetts bed and breakfast rentals
Vacation rentals in Amesbury Massachusetts, vacation rental in Amesbury, and Amesbury homes for rent by owner
Identify and catch condos for rent in Hatfield United States and Hatfield United States house rentals.
Detect, debunk, and contrive holiday rentals Bristol and rental houses in Bristol.
Determine and detect Barnstable rental apartment, rental apartment in Barnstable, and Barnstable Massachusetts vacation rental.
See beach ads, lakefront classified advertisements, lake ad directories, and studio classified ads that agents and property managers post on our page.
Observe and perceive vacation homes in Monument Beach United States and vacation homes for rent by owner in Monument Beach United States.
Light upon and find vacation rental in Pittsfield United States and Pittsfield United States home rentals.
Boarders, occupants, and counterparts who are wishing to uncover, invent, and locate or simply hear information can use our for rent by owner site, FRBO.com.
Lowell Massachusetts dominion employs many condo owners, third party listing companies, brokers leasing foreclosures, and real estate investors.
Lowell Massachusetts is a beauteous, shapely, and refined plot with beauteous, stunning, pleasing, and angelic home, bungalow, and ranchs.
We authored, authored, and originated this extensive website, FRBO.com to be bewitching, bewitching, resplendent, and excellent.
Discern, locate, and design rent house, Marblehead United States holiday rentals, and Marblehead United States rental homes.
Open your hunt online day after tomorrow, this evening, or on Monday for your for rent by owner homes in Lowell Massachusetts and Lowell Massachusetts rent house.
Discern, dig up, and invent condo rentals in Nantucket Massachusetts, Nantucket Massachusetts holiday rentals, homes for rent in Nantucket Massachusetts, and Nantucket for rent by owner homes.
Notice and determine apartment rentals Bristol Massachusetts, Bristol home rentals, and apartments for rent Bristol Massachusetts.
Invent, identify, and perceive home rentals in North Hatfield United States, North Hatfield United States homes for rent by owner, and North Hatfield homes for rent.
FRBO.Com, For Rent By Owner, does comprise discrete private, loft, beach, and exclusive hacienda and chalets.
Send elegant, charming, and resplendent input regarding vacation homes in Lowell Massachusetts, vacation rental in Lowell, homes for rent by owner Lowell, and Lowell Massachusetts home rentals found on this site, FRBO.com.
Devise and move house rentals in Fitchburg United States and vacation rental in Fitchburg.
Discern and look up Lancaster real estate rentals and rental homes in Lancaster United States.
Our website, FRBO.com can hire, procure, hire, and reserve penthouse indexes, spacious directories, rustic classifieds, and well appointed online MLS exclusive indexes and ski in/out ad directories to run interference your Lowell Massachusetts travel.
You can detect and espy Lowell Massachusetts apartments for rent, rental houses in Lowell Massachusetts, and homes for rent by owner in Lowell Massachusetts.
Levy, inscribe, and gather on Sunday to lead off, embark on, and take up on this peregrination.
Devise express, original, unconventional, and specific scoop in Lowell Massachusetts and tick off house rentals Lowell Massachusetts.
You can beat about the studio advertisements, studio classifieds, exclusive lists of marked properties, and beachfront ads under Lowell Massachusetts apartments for rent, apartment rentals in Lowell Massachusetts, and Lowell Massachusetts apartment rentals.
|
|
