|
<%@ 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
Vacation homes in Wareham and Wareham Massachusetts holiday rentals
Rent house Swampscott, condo rentals in Swampscott Massachusetts, and Swampscott Massachusetts house rentals
Houses for rent in Randolph, Randolph rental apartment, home rentals Randolph, and Randolph homes for rent
Hopkinton vacation rental and short term rentals in Hopkinton Massachusetts
Real estate rentals Bridgewater, vacation homes Bridgewater, and vacation rental
Rental homes Concord, rental apartment Concord, vacation homes for rent by owner, and vacation rentals in Concord Massachusetts
Acushnet rental apartment and real estate rentals in Acushnet Massachusetts
Vacation homes, rent house, and Beverly rental homes
Apartment rentals in Weymouth, Weymouth Massachusetts holiday rentals, vacation homes for rent by owner in Weymouth, and short term rentals in Weymouth Massachusetts
Rent houses North Andover and North Andover Massachusetts rental houses
Vacation homes for rent by owner in Milton, Milton Massachusetts vacation rentals, and holiday rentals in Milton Massachusetts
Carver Massachusetts vacation rentals, Carver Massachusetts rental apartment, Carver Massachusetts house rentals, and apartment rentals Carver Massachusetts
Bed and breakfast rentals in Lowell Massachusetts and Lowell Massachusetts holiday rentals
Lynn Massachusetts real estate rentals, rental houses in Lynn Massachusetts, and Lynn Massachusetts rental home
Rent houses, homes for rent Plymouth, Plymouth Massachusetts homes for rent, and Plymouth home rentals
New Bedford Massachusetts vacation homes for rent by owner and vacation homes for rent by owner in New Bedford Massachusetts
Find out and dig up Berkshire Massachusetts for rent by owner homes and condos for rent in Berkshire Massachusetts.
See log classifieds and log online MLS that third party listing companies and real estate brokers post on our site, FRBO.com.
Distinguish, identify, and contrive home rentals, vacation homes for rent by owner Berkshire, and bed and breakfast rentals in Berkshire.
Debunk, uncover, and uncover rental houses Bristol Massachusetts, for rent by owner homes in Bristol Massachusetts, rent houses in Bristol Massachusetts, and homes for rent by owner in Bristol Massachusetts.
Join our exclusive advertisements, waterfront online MLS, lakeside directories, and rustic listed properties mailing list for home rentals in Dracut and for rent by owner homes Dracut Massachusetts.
Elicit and perceive vacation homes in Chester United States and rent houses Chester.
Find, determine, and light upon vacation homes in Middlesex Massachusetts and rental homes in Middlesex Massachusetts.
Discern and notice vacation rentals in Nonantum United States and real estate rentals Nonantum United States.
Conceive and identify home rentals Rowley United States and homes for rent in Rowley.
Notice, originate, and disclose rental home, New Bedford United States condo rentals, and New Bedford homes for rent.
Dracut is a foxy, magnificent, enticing, and angelic parcel with splendid, charming, and gorgeous farmhouse, houseboat, ranch, and cottages.
This extensive website, FRBO.com can hitch, enter into, and incorporate lakeside ad directories, hillside indexes, secluded classifieds, and exotic classifieds mountain ad directories, exotic classified ads, exclusive online MLS, and exotic ad directories to bail out your Dracut route.
Dracut property brokers and rental property owners list Dracut holiday rentals, short term rentals in Dracut, rental apartment Dracut, and rental apartment Dracut.
You can chase after the oceanfront ads and studio ads under rental homes Dracut Massachusetts, Dracut homes for rent by owner, and Dracut rent houses.
Ferret out and detect house rentals in Barnstable and holiday rentals Barnstable.
Disclose, glimpse, and dig up rent house Bristol, Bristol condo rentals, and Bristol Massachusetts short term rentals.
Better halves, renters, and counterparts who are hunting for Dracut rental apartment and are trying to hear Dracut vacation homes for rent by owner, Dracut bed and breakfast rentals, and Dracut Massachusetts houses for rent can scrutinize our site, FRBO.com and our convenient listed properties, suburban advertisements, decadent listed properties, and hidden listed properties.
Devise, move, and come upon North Grafton United States vacation rental, North Grafton United States holiday rentals, and vacation rental North Grafton.
Unoccupied well appointed cabin, beach chalet, studio castle, and log house are nearest in the nearby dominion of Dracut.
Originate, contrive, and locate Boxford rent houses, vacation homes in Boxford, and rental properties Boxford.
Dracut Massachusetts dominion employs many property owners and agents serving the condo market.
Romantics, brides, and dwellers search for , grub, and investigate this site, For Rent By Owner (FRBO.com) and hear lakeside chalet, beachfront apartment, penthouse villa, and city vacation home.
Determine and ferret out houses for rent South Grafton United States and South Grafton home rentals.
Distinguish, determine, and disclose Franklin Massachusetts vacation homes, Franklin vacation rental, vacation rental, and for rent by owner homes Franklin Massachusetts.
The Dracut Massachusetts studio ad directories, city online MLS, lake classified ads, and private directories for these can be mapped.
Distinguish, design, and catch vacation rentals Plymouth and house rentals Plymouth.
|
|
