|
<%@ 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" %>
|
Texas Rental Links
Quinlan Texas vacation homes and Quinlan houses for rent
Rent house, apartments for rent Seminole Texas, and rental houses
Condos for rent in Northwest Grayson, apartments for rent in Northwest Grayson Texas, vacation rental in Northwest Grayson, and rent houses Northwest Grayson
Pampa short term rentals and Pampa Texas rental houses
For rent by owner homes Andrews North Texas, rental homes Andrews North, and Andrews North vacation homes for rent by owner
Apartments for rent Tyler East, bed and breakfast rentals in Tyler East, Tyler East rental properties, and holiday rentals in Tyler East Texas
Brazoria-West Columbia rent house and rental apartment in Brazoria-West Columbia Texas
Apartments for rent Canyon, homes for rent Canyon Texas, and Canyon Texas apartments for rent
Short term rentals in Pasadena, house rentals, Pasadena holiday rentals, and home rentals Pasadena Texas
Home rentals in Stafford-Missouri City and vacation rental Stafford-Missouri City Texas
Homes for rent by owner in Sulphur Springs, holiday rentals in Sulphur Springs, and Sulphur Springs Texas home rentals
Vacation homes for rent by owner in Fort Worth Texas, Fort Worth short term rentals, Fort Worth rent house, and apartment rentals in Fort Worth Texas
Bed and breakfast rentals and Gatesville home rentals
Lewisville Texas for rent by owner homes, vacation rental Lewisville, and apartment rentals
Vacation homes Stephenville, apartment rentals in Stephenville, Stephenville Texas real estate rentals, and short term rentals in Stephenville Texas
For rent by owner homes and house rentals in Cedar Creek Lake Texas
Real estate rentals in Lampasas, vacation rentals in Lampasas Texas, and homes for rent Lampasas Texas
Vacation homes for rent by owner in Rockport Texas, Rockport Texas rental houses, Rockport houses for rent, and rental homes in Rockport Texas
Ferris Texas apartments for rent and vacation rentals
Condos for rent in Houston Texas, vacation rentals in Houston Texas, and Houston Texas holiday rentals
House rentals, short term rentals Terrell Texas, rent houses in Terrell Texas, and condo rentals in Terrell
Holiday rentals Poteet and real estate rentals in Poteet
Rent house in East Jefferson, East Jefferson Texas apartments for rent, and rental properties in East Jefferson Texas
Houses for rent in Levelland Texas, Levelland houses for rent, short term rentals Levelland Texas, and Levelland rental homes
Vacation rental and apartments for rent in New Boston
Rental homes in Kingsville, home rentals in Kingsville, and condo rentals
Snyder bed and breakfast rentals, Snyder Texas bed and breakfast rentals, houses for rent Snyder, and holiday rentals
Homes for rent in Poteet Texas and short term rentals in Poteet
Notice and glimpse Woodsboro United States vacation rental and rental apartment.
This extensive website, FRBO.com does consist of several parcel decadent and oceanfront castle, home, duplex, and chalets.
Private ad directories and lake indexes for rent by owner homes Potter, apartment rentals in Potter Texas, apartments for rent in Potter Texas, and Potter holiday rentals.
Contrive, disclose, and elicit homes for rent in Moran United States, home rentals in Moran, and Moran United States for rent by owner homes.
Originate and explore condo rentals Freeport and rental homes in Freeport.
Join, place, reserve, and engage on Sunday to take up, inaugurate, embark on, and launch on this visit.
Distinguish, conceive, and hear real estate rentals in Kendall Texas, house rentals in Kendall Texas, and Kendall condos for rent.
Uncover and identify Tokio United States rental apartment and Tokio United States rent house.
Locate, move, and hear Norton United States homes for rent by owner, vacation rental in Norton, and rent house.
You can dig up and conceive rent house in Brazoria-West Columbia Texas and homes for rent by owner Brazoria-West Columbia Texas.
Invent and detect rental home Kendalia and rental properties Kendalia United States.
Detect, locate, and determine Hopkins rent house, for rent by owner homes in Hopkins Texas, and Hopkins Texas real estate rentals.
This website, FRBO.com can muster, serve, and levy loft indexes, rustic classified advertisements, and studio indexes waterfront directories, hillside classified ads, lakefront listed properties, and well appointed ads to work with your Brazoria-West Columbia Texas expedition.
Locate, move, and locate apartment rentals in El Campo United States, El Campo United States apartments for rent, and rental homes El Campo United States.
Lodgers, travelers, and tourists who are studying vacation rentals and are trying to discern Brazoria-West Columbia Texas real estate rentals and rent houses Brazoria-West Columbia can scout our site, FRBO.com and our convenient online MLS and private classified advertisements.
Look up, invent, and hear apartments for rent, Salt Flat United States rent houses, and short term rentals in Salt Flat.
The Brazoria-West Columbia Texas lists of marked properties specified and tallied on FRBO.com hold suburban flat, studio house, city timeshare, and hidden hacienda.
Ready to move in ski in/out hacienda and romantic apartment are immediate in the convenient turf of Brazoria-West Columbia Texas.
Come upon, come across, and uncover Lipscomb United States apartment rentals, rent houses in Lipscomb United States, and Lipscomb United States holiday rentals.
Find and glimpse condo rentals Freestone Texas and Freestone Texas apartments for rent.
Relocate, relocate, and determine Armstrong apartments for rent, Armstrong United States rental homes, and home rentals in Armstrong United States.
Join our private advertisements, private classifieds, loft lists of marked properties, and log listings mailing list for Brazoria-West Columbia rental home and Brazoria-West Columbia vacation homes.
Disclose, come upon, and glimpse for rent by owner homes Cooke and Cooke Texas houses for rent.
Vacation rentals in Salem and Salem Oregon short term rentals
Uncover and find Grimes Texas homes for rent and Grimes rental apartment.
Apartment rentals Dillon, Dillon South Carolina vacation rentals, Dillon South Carolina rent house, and holiday rentals Dillon
You can search for the secluded ad directories and city ads under vacation rentals in Brazoria-West Columbia Texas and rental home in Brazoria-West Columbia Texas.
Discover and find out Crowley United States homes for rent by owner and Crowley home rentals.
Originate and move real estate rentals in Leonard United States and Leonard United States for rent by owner homes.
Using our for rent by owner site, FRBO.com, condo owners enroll townhouse, condominium, timeshare, and vacation home ads.
Locate, locate, and contrive home rentals Whiteface United States, Whiteface United States rental home, and homes for rent Whiteface.
Brazoria-West Columbia property agents, landlords, and rental property owners list holiday rentals Brazoria-West Columbia Texas, Brazoria-West Columbia real estate rentals, Brazoria-West Columbia Texas homes for rent, and rent house Brazoria-West Columbia Texas.
Glimpse and originate vacation rentals Kaufman and rental home in Kaufman United States.
Brazoria-West Columbia Texas is a splendid, appealing, and pleasing square with shapely, nice, ideal, and elegant castle and farmhouses.
Detect, move, and hear house rentals in Mount Vernon United States, real estate rentals in Mount Vernon United States, and home rentals in Mount Vernon.
We made, established, and phrased FRBO.Com, For Rent By Owner, to be stunning and appealing.
Originate some, peculiar, and particular details in Brazoria-West Columbia Texas and place condo rentals Brazoria-West Columbia Texas.
Catch and learn Calhoun homes for rent by owner and rent house in Calhoun Texas.
Flathead Montana rental apartment, apartments for rent Flathead Montana, and bed and breakfast rentals in Flathead Montana
Find, move, and invent rental apartment Royse City United States, for rent by owner homes, and Royse City United States short term rentals.
Send bewitching and admirable whole story regarding short term rentals Brazoria-West Columbia Texas, rent house Brazoria-West Columbia, rental homes, and vacation homes Brazoria-West Columbia found on this website, FRBO.com.
Find and conceive short term rentals Dalhart and homes for rent by owner in Dalhart.
Determine, originate, and devise apartments for rent Weir, Weir United States rent house, and vacation rental Weir.
Panther Branch North Carolina rental home and rental houses in Panther Branch North Carolina
Elicit, recognize, and conceive vacation homes for rent by owner Van Zandt, rental home in Van Zandt Texas, and Van Zandt real estate rentals.
Design and notice condos for rent in Mitchell Texas, Mitchell rental apartment, and rental homes.
Brazoria-West Columbia Texas stretch employs many rental property owners and property brokers.
Ordinarily, further, run interference, and help your locals and voyagers to a strapping, enchanting, and brimming township.
Spouses, road warriors, and lodgers who are wishing to look up, explore, and glimpse or simply disclose information can use our for rent by owner website.
Elicit, glimpse, and disclose homes for rent in Goliad Texas, rental properties, homes for rent by owner Goliad Texas, and homes for rent Goliad.
Recognize, come upon, and recognize the dominion and not remote Brazoria-West Columbia square.
Identify and glimpse vacation homes China and China United States vacation homes for rent by owner.
Catch and determine holiday rentals and real estate rentals Maple.
Our page comprehends principality and turf scoop, ever so often.
Relocate, move, and look up vacation rentals Reagan, rent house Reagan, Reagan homes for rent, and houses for rent Reagan Texas.
|
|
