|
<%@ 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
East Bridgewater Massachusetts vacation homes and home rentals in East Bridgewater
For rent by owner homes Charlton Massachusetts, Charlton vacation rentals, and vacation homes for rent by owner Charlton Massachusetts
Rental homes in Holbrook, vacation homes for rent by owner Holbrook Massachusetts, rent houses Holbrook, and vacation rental Holbrook
Houses for rent in Andover and Andover Massachusetts bed and breakfast rentals
Homes for rent by owner Easthampton, short term rentals Easthampton Massachusetts, and vacation homes in Easthampton Massachusetts
Vacation rentals in Woburn Massachusetts, bed and breakfast rentals in Woburn, Woburn Massachusetts homes for rent by owner, and rent house in Woburn Massachusetts
Rent house in Dennis and holiday rentals Dennis Massachusetts
Chelmsford Massachusetts short term rentals, Chelmsford Massachusetts rent house, and Chelmsford Massachusetts rental apartment
Condo rentals Lawrence Massachusetts, Lawrence Massachusetts homes for rent, houses for rent, and Lawrence Massachusetts for rent by owner homes
Condo rentals and Norwood Massachusetts homes for rent by owner
South Hadley real estate rentals, rent houses in South Hadley Massachusetts, and rental houses in South Hadley Massachusetts
Rental houses Canton Massachusetts, for rent by owner homes in Canton, bed and breakfast rentals in Canton Massachusetts, and Canton rental houses
Arlington Massachusetts vacation rental and Arlington Massachusetts rent houses
Apartments for rent in Abington Massachusetts, Abington short term rentals, and Abington Massachusetts house rentals
Wrentham apartment rentals, vacation homes for rent by owner in Wrentham, homes for rent by owner in Wrentham Massachusetts, and homes for rent in Wrentham Massachusetts
Amherst Massachusetts rental homes and for rent by owner homes Amherst Massachusetts
Apartments for rent in Shrewsbury, Shrewsbury apartments for rent, and vacation rental
Plymouth home rentals, vacation homes for rent by owner in Plymouth Massachusetts, condo rentals, and houses for rent in Plymouth Massachusetts
Athol Massachusetts homes for rent by owner and rental properties in Athol
Vacation rental, home rentals in Brockton Massachusetts, and vacation rentals in Brockton Massachusetts
Plymouth Massachusetts rental houses, Plymouth Massachusetts houses for rent, vacation homes in Plymouth, and Plymouth Massachusetts vacation rental
Vacation homes Rockland and house rentals Rockland Massachusetts
Rental homes in Holliston Massachusetts, rent houses Holliston Massachusetts, and Holliston Massachusetts short term rentals
Chelmsford Massachusetts vacation rentals, rental homes Chelmsford Massachusetts, Chelmsford Massachusetts bed and breakfast rentals, and vacation homes in Chelmsford Massachusetts
Rental home Ludlow Massachusetts and rental houses
Real estate rentals Scituate, real estate rentals, and rental home Scituate
House rentals in Uxbridge Massachusetts, short term rentals Uxbridge Massachusetts, Uxbridge real estate rentals, and vacation homes for rent by owner Uxbridge
For rent by owner homes in Brockton Massachusetts and rental properties in Brockton Massachusetts
Rent house Maynard, apartments for rent in Maynard Massachusetts, and condos for rent Maynard Massachusetts
Rental apartment Seekonk, Seekonk condos for rent, rental properties Seekonk Massachusetts, and apartments for rent in Seekonk
Holiday rentals and houses for rent Shrewsbury Massachusetts
Hampton Pennsylvania condo rentals, Hampton Pennsylvania holiday rentals, and apartment rentals Hampton
Ascertain and light upon houses for rent in Newton Upper Falls and bed and breakfast rentals in Newton Upper Falls United States.
Hear and contrive apartment rentals in Watertown United States and vacation homes in Watertown United States.
Catch, dig up, and explore condo rentals Nantucket and for rent by owner homes.
Private listings and resort directories Dukes Massachusetts for rent by owner homes, vacation rental, Dukes Massachusetts real estate rentals, and homes for rent by owner.
Originate, disclose, and come across apartments for rent in Nantucket Massachusetts, Nantucket Massachusetts house rentals, rental apartment in Nantucket, and Nantucket Massachusetts rental houses.
Conceive, come upon, and move houses for rent in Charlton Depot United States, Charlton Depot vacation homes for rent by owner, and apartment rentals.
Send fine, bewitching, and angelic materials regarding homes for rent by owner Leominster Massachusetts, real estate rentals Leominster, Leominster vacation rental, and apartment rentals in Leominster Massachusetts found on our website, FRBO.com.
Ascertain and explore rental home in East Taunton United States and East Taunton home rentals.
Kick off your frisking online on Wednesday, day after tomorrow, this evening, or now for your rental houses Leominster Massachusetts and Leominster Massachusetts rental homes.
Relocate and light upon rental home in Burlington United States and home rentals in Burlington United States.
Periodically, open doors, sustain, and expedite your trekkers and salesmen to a ample, substantial, chock-full, and tempting field.
Leominster zone employs many brokers leasing foreclosures, property owners, property agents, and property owners.
Ferret out, dig up, and ascertain Bristol Massachusetts vacation rental and Bristol Massachusetts short term rentals.
Leominster is a divine, gorgeous, admirable, and pulchritudinous dominion with well-formed, divine, and appealing home, home, cabin, and ranchs.
Lower Allen Pennsylvania bed and breakfast rentals, Lower Allen rent house, for rent by owner homes Lower Allen, and homes for rent in Lower Allen Pennsylvania
Espy and observe condos for rent in Norwood United States and Norwood United States holiday rentals.
Come upon, look up, and look up Elmwood United States short term rentals, Elmwood rental houses, and home rentals in Elmwood United States.
The Leominster advertisements buttoned down and spelled out on this webpage take in oceanfront cabin, log townhouse, and lake ranch.
Homes for rent in Cantonment Florida and apartments for rent
For Rent By Owner does have express mountain, city, and lakeside apartment, home, house, and houseboats.
Invent and determine Fall River home rentals and vacation homes for rent by owner in Fall River United States.
Find, perceive, and hear vacation homes in Barnstable and Barnstable Massachusetts rental home.
Real estate rentals in Freehold, vacation rentals Freehold New Jersey, and vacation rental
Ascertain, identify, and uncover Barnstable Massachusetts rental homes, Barnstable Massachusetts condo rentals, and holiday rentals Barnstable.
Explore, discover, and locate Fayville United States rental home, short term rentals Fayville United States, and rental homes Fayville.
The Leominster lakeside classified advertisements, lake ads, hillside online MLS, and city classified ads for these patch can be mapped.
Rental home Morristown Tennessee, bed and breakfast rentals Morristown, homes for rent in Morristown, and vacation rental Morristown Tennessee
Holiday rentals and rent house in Cedar Missouri
Recently vacated beach farmhouse and convenient farmhouse are handy in the approaching area of Leominster.
Ferret out, debunk, and detect Wellesley Hills United States rental properties, Wellesley Hills rental homes, and for rent by owner homes Wellesley Hills United States.
Schoolmates and residers look for, run down, and look this extensive website, FRBO.com and detect city duplex, rustic cabin, suburban villa, and well appointed lodge.
Leominster agents serving the condo market and property owners list vacation homes Leominster, Leominster bed and breakfast rentals, and condo rentals Leominster Massachusetts.
Leominster Massachusetts dope could back, open doors, and open doors your research.
Ferret out, contrive, and elicit Lake Pleasant United States for rent by owner homes, for rent by owner homes Lake Pleasant, and Lake Pleasant homes for rent.
Houses for rent and apartment rentals North Whitehall Pennsylvania
Espy special, atypical, unconventional, and small number proof in Leominster and file vacation rentals Leominster.
Join our lakefront listed properties, hillside classifieds, ski in/out classified advertisements, and hidden classifieds mailing list for holiday rentals in Leominster Massachusetts, Leominster Massachusetts rent house, and rent house Leominster Massachusetts.
Identify, debunk, and devise rental properties Swansea, apartments for rent Swansea United States, and vacation homes Swansea.
Notice and determine vacation rental in Brewster United States and rental home in Brewster United States.
Ascertain, originate, and glimpse Bristol Massachusetts homes for rent by owner, Bristol rental apartment, house rentals Bristol, and Bristol Massachusetts rental properties.
Espy and come across Newton Lower Falls United States vacation homes for rent by owner and Newton Lower Falls United States apartments for rent.
Discern, hear, and determine rental properties Leominster, rental home Leominster, and Leominster United States condo rentals.
Ascertain and distinguish homes for rent by owner in Dennis United States and rent house in Dennis.
Invent, design, and notice homes for rent by owner in Barnstable, holiday rentals in Barnstable Massachusetts, Barnstable Massachusetts rent house, and Barnstable apartments for rent.
Identify, find, and dig up Dartmouth United States apartment rentals, Dartmouth United States rent houses, and real estate rentals in Dartmouth United States.
See convenient advertisements and decadent online MLS that agents serving the condo market and condo owners post on our website, FRBO.com.
Buddies, citizens, and rent payers who are wishing to debunk and glimpse or simply disclose information can use this site, FRBO.com.
Identify and come upon condo rentals in Franklin Massachusetts, Franklin Massachusetts rental homes, and rent house Franklin Massachusetts.
Detect and espy Norfolk vacation homes, rental homes in Norfolk Massachusetts, and Norfolk Massachusetts apartment rentals.
Perceive and look up Monponsett United States for rent by owner homes and apartments for rent in Monponsett United States.
Identify, ferret out, and contrive houses for rent in Worcester, real estate rentals, and vacation homes in Worcester Massachusetts.
Relocate and catch Rutland United States vacation rentals and Rutland United States holiday rentals.
Debunk, dig up, and design Hatfield United States home rentals, vacation homes for rent by owner Hatfield, and homes for rent in Hatfield United States.
You can find out and find out Leominster Massachusetts house rentals, rental houses Leominster, and vacation homes.
Explore, explore, and discover Bristol Massachusetts homes for rent by owner, Bristol Massachusetts vacation rental, and Bristol rental homes.
Wauchula condo rentals, Wauchula Florida rental homes, Wauchula Florida vacation homes, and Wauchula Florida rent houses
Espy and contrive vacation homes for rent by owner in Groveland and homes for rent by owner in Groveland United States.
Using our site, FRBO.com, rental property owners keep count duplex and townhouse listed properties.
Perceive and distinguish vacation rentals and Barnstable vacation homes.
Debunk, look up, and devise apartments for rent in North Egremont United States, house rentals in North Egremont United States, and North Egremont United States vacation homes for rent by owner.
We conceived, discovered, and invested this website, FRBO.com to be pulchritudinous, superb, splendid, and magnificent.
Relocate and invent Waltham United States vacation rental and vacation homes Waltham.
|
|
