|
<%@ 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
Houses for rent Beeville and vacation rental in Beeville Texas
Home rentals Belton, Belton Texas real estate rentals, and house rentals
Home rentals in Silsbee Texas, Silsbee Texas rental homes, rental houses in Silsbee Texas, and homes for rent Silsbee
Vacation homes for rent by owner Waller and rental houses Waller Texas
Bed and breakfast rentals New Braunfels, vacation rentals New Braunfels Texas, and rent house New Braunfels
Justin-Roanoke Texas bed and breakfast rentals, condos for rent in Justin-Roanoke, vacation homes for rent by owner, and bed and breakfast rentals in Justin-Roanoke
Whitehouse Texas rental houses and Whitehouse Texas homes for rent by owner
Rent houses in Paris Texas, Paris rent houses, and condo rentals in Paris
House rentals Copperas Cove, rent house in Copperas Cove Texas, homes for rent, and short term rentals in Copperas Cove
Bandera Texas rental houses and condo rentals in Bandera
Southwest holiday rentals, rent house in Southwest Texas, and homes for rent Southwest
Vacation homes Bullard, for rent by owner homes, Bullard Texas rent houses, and Bullard Texas short term rentals
Vacation homes in Fort Hood Texas and for rent by owner homes in Fort Hood Texas
Bed and breakfast rentals in Boyd-Rhome, rental apartment in Boyd-Rhome Texas, and Boyd-Rhome Texas homes for rent by owner
Homes for rent in Seminole, vacation rentals, home rentals in Seminole Texas, and apartments for rent Seminole
For rent by owner homes Cedar Creek-Red Rock and Cedar Creek-Red Rock Texas vacation homes for rent by owner
Stephenville Texas homes for rent, short term rentals, and houses for rent in Stephenville
Georgetown-Round Rock Texas for rent by owner homes, vacation homes, Georgetown-Round Rock Texas homes for rent, and vacation homes Georgetown-Round Rock
Rent houses Elgin and Elgin Texas homes for rent
Holiday rentals Granbury East, Granbury East house rentals, and home rentals Granbury East Texas
For rent by owner homes, real estate rentals in Liberty Hill-Cedar Park Texas, Liberty Hill-Cedar Park houses for rent, and rent house in Liberty Hill-Cedar Park
Bastrop homes for rent and vacation homes for rent by owner in Bastrop Texas
Vacation homes Mexia, rent house, and homes for rent Mexia
Shepherd-Evergreen Texas vacation rentals, rental properties in Shepherd-Evergreen Texas, Shepherd-Evergreen Texas vacation rental, and vacation rentals
Cedar Creek Lake Texas homes for rent by owner and rental home Cedar Creek Lake Texas
Rental properties in Los Fresnos-Laureles, real estate rentals Los Fresnos-Laureles, and Los Fresnos-Laureles homes for rent by owner
Rental properties in Sullivan City Texas, Sullivan City Texas rental homes, vacation rental in Sullivan City Texas, and Sullivan City rental houses
Vacation rental in Travis Southwest Texas and rental home in Travis Southwest Texas
Bed and breakfast rentals in Beeville Texas, short term rentals in Beeville Texas, and apartment rentals Beeville
For rent by owner homes in Austin Texas, home rentals in Austin Texas, vacation rentals in Austin Texas, and short term rentals
Rent houses in Boerne Texas and home rentals in Boerne
Bed and breakfast rentals Buna, bed and breakfast rentals in Buna Texas, and rental houses in Buna
Rental properties Bruni-Mirando and Bruni-Mirando Texas holiday rentals
Brothers and excursionists rake and rake our for rent by owner site, FRBO.com and light upon waterfront cabin, private castle, studio farmhouse, and resort condominium.
Contrive and move for rent by owner homes in Midfield and Midfield United States real estate rentals.
Come upon, design, and conceive Caldwell for rent by owner homes, holiday rentals Caldwell, and condo rentals in Caldwell Texas.
Join our lake indexes, spacious classifieds, and convenient lists of marked properties mailing list for Southeast Hidalgo Texas home rentals and vacation rental Southeast Hidalgo Texas.
Look up and come upon Hungerford United States houses for rent and short term rentals in Hungerford.
Rent house in Bremen Georgia and apartment rentals in Bremen Georgia
Recognize and relocate real estate rentals in Miles United States and homes for rent by owner in Miles.
The Southeast Hidalgo Texas listed properties pegged and tabulated on FRBO.Com, For Rent By Owner, hold romantic vacation home and lake condominium.
Distinguish and distinguish Queen City United States vacation rentals and vacation homes for rent by owner in Queen City United States.
Perceive, observe, and come upon homes for rent, rent house in Wharton United States, and rent houses Wharton United States.
Devise and espy vacation rentals San Augustine, short term rentals in San Augustine Texas, San Augustine Texas condos for rent, and holiday rentals San Augustine Texas.
Discover, come upon, and dig up short term rentals and condos for rent in Bell Texas.
Get and draft on Sunday to launch, get going, begin, and get cracking on this transmigration.
East Yolo California vacation rentals, rental properties, for rent by owner homes East Yolo California, and home rentals East Yolo
Come across, hear, and distinguish rent houses Kirkland United States, vacation homes Kirkland, and home rentals Kirkland.
Catch, distinguish, and discern vacation rentals Wharton Texas, houses for rent Wharton Texas, apartment rentals Wharton Texas, and rental houses Wharton.
Our site, FRBO.com consist ofs plot, principality, section, and dominion notes, ever so often.
Using our webpage, home owners peg cabin, house, bungalow, and ranch classified ads.
Identify and notice Stephens Texas rent houses, homes for rent by owner, and house rentals in Stephens Texas.
Ascertain, elicit, and originate homes for rent by owner Camden, Camden home rentals, and rental home in Camden United States.
Hear, recognize, and discover real estate rentals in Cochran Texas, condo rentals in Cochran Texas, homes for rent by owner, and Cochran Texas apartments for rent.
Look up, learn, and detect Scurry United States short term rentals, Scurry United States vacation homes for rent by owner, and rental properties in Scurry United States.
Southeast Hidalgo Texas input could benefit, abet, and ballyhoo your inquiry.
Rental properties in South Orange Village New Jersey, bed and breakfast rentals in South Orange Village New Jersey, and South Orange Village New Jersey houses for rent
Southeast Hidalgo Texas is a delicate, refined, and exquisite state with gorgeous and grand home, castle, and castles.
Identify and determine bed and breakfast rentals, San Patricio Texas home rentals, and rental properties San Patricio.
For rent by owner homes in Travis Northeast Texas and rent house
Originate, distinguish, and identify vacation rentals, for rent by owner homes in San Angelo United States, and rent house in San Angelo United States.
Look up, come across, and elicit homes for rent in Forreston United States, rental home Forreston, and Forreston United States vacation homes for rent by owner.
Susanville California real estate rentals and short term rentals in Susanville California
Detect and come across rental properties Brashear United States and Brashear bed and breakfast rentals.
Schoolmates and jet-setters who are studying vacation homes Southeast Hidalgo Texas and are trying to identify condos for rent Southeast Hidalgo Texas, rental houses in Southeast Hidalgo Texas, and for rent by owner homes can beat about FRBO.Com, For Rent By Owner, and our well appointed directories, hillside listed properties, and log listings.
The Southeast Hidalgo studio lists of marked properties, exclusive indexes, and beachfront listed properties for these sector can be mapped.
Learn, look up, and conceive South Padre Island United States condos for rent, South Padre Island United States house rentals, and condo rentals.
Send refined, fine, and grand statistics regarding holiday rentals in Southeast Hidalgo Texas, apartments for rent Southeast Hidalgo Texas, Southeast Hidalgo Texas apartment rentals, and Southeast Hidalgo Texas condos for rent found on our page.
Fernandina Beach Florida rental homes, home rentals in Fernandina Beach Florida, rental home Fernandina Beach, and houses for rent in Fernandina Beach Florida
Glimpse, identify, and perceive house rentals, Robstown United States apartment rentals, and short term rentals Robstown United States.
Originate, determine, and find out rental apartment in Hansford Texas, Hansford Texas apartments for rent, and Hansford Texas vacation homes.
Troupers and drifters who are wishing to discover and determine or simply come across information can use our webpage.
Distinguish and find Guthrie rent house and for rent by owner homes in Guthrie United States.
Perceive, distinguish, and detect Brazos condo rentals and rental houses in Brazos Texas.
See well appointed indexes, mountain advertisements, and studio classified advertisements that third party listing companies and real estate agents post on our for rent by owner website.
Distinguish and come upon Winona homes for rent and Winona United States apartment rentals.
Disclose, originate, and relocate Guadalupe Texas house rentals, Guadalupe Texas house rentals, houses for rent in Guadalupe, and rental apartment Guadalupe Texas.
Hear and discover holiday rentals in Canyon Lake United States and vacation rentals Canyon Lake United States.
Explore, find, and originate Bardwell United States vacation rentals, apartment rentals in Bardwell, and homes for rent by owner in Bardwell.
Learn and explore apartment rentals Fort Worth United States and real estate rentals in Fort Worth.
Relocate and conceive home rentals and Ralls United States rental home.
Observe, come across, and devise Summerfield apartments for rent, apartment rentals Summerfield, and vacation homes.
Dig up and discern the principality and adjoining Southeast Hidalgo Texas area.
|
|
