Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T16:41:25.840' ,`MLSNumber` = '28944457' ,`ListAgentFullName` = 'Luis Perret' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = 'Candice Vieira' ,`SellingOfficeName` = 'Better Real Estate, LLC' ,`Latitude` = '29.574735' ,`Longitude` = '-95.063873' ,`PhotoCount` = '36' ,`PostalCode` = '77586' ,`RoomCount` = '4' ,`ListPrice` = '375000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Highknoll' ,`StreetNumber` = '4110' ,`StreetSuffix` = 'Lane' ,`City` = 'Seabrook' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Huge price drop** Make this beautiful place your forever home in the Clear Lake Forest community, property does need some updating but at this bargain you can make it your own. 3-4 bedroom home with beautiful Saltillo flooring throughout most of the downstairs. There’s ton of living space in this home to make it your own. One side of the home has 3 bedrooms including the master and the other side has a huge bedroom/game room above the garage with cedar walls. There are 3 full baths upstairs and 2 half down stairs. Kitchen comes with chefs Viking cooktop, 2 sinks and 2 dishwashers! There is a big island to prep your meals and plenty of counter space. There is 2 large living areas with one that has a wet bar and room for your wine chiller. Roof is less than 2 years old. Ever dream of having your own private sauna, here’s your chance! There is plenty to see so book your appointment to see this gem!' ,`Acres` = '0.2802' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 8 CLEAR LAKE FOREST SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12204' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Lake Forest Sec 02' ,`TaxAmount` = '7407' ,`TaxRate` = '2.279' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709042' WHERE `Matrix_Unique_ID` = '205736932' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T17:26:34.440' ,`MLSNumber` = '44567199' ,`ListAgentFullName` = 'Laura Crisp' ,`ListOfficeName` = 'Bob Peltier & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.657573' ,`Longitude` = '-95.622268' ,`PhotoCount` = '11' ,`PostalCode` = '77498' ,`RoomCount` = '4' ,`ListPrice` = '329375.00' ,`Status` = 'Active' ,`StreetName` = 'Elder Bridge' ,`StreetNumber` = '13530' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2166' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful home....Close to 59, Great Schools, walking distance to Walmart and close to other shopping. HARD WOOD FLOORS! Roof replaced in 2018, recently replaced A/C, working security cameras and more! Appliances and furnishing including the several flat screen tvs on walls can stay with the home with acceptable offer!!! Perfect sized privacy fenced back yard with patio has room enough for pool and a play set and more! Huge primary bedroom on 1st floor with large walk-in closet in primary bath. 3 Very good sized bedrooms upstairs. ). You will love relaxing or entertaining in the Great room enjoying the cathedral ceilings and a fire in the fireplace. Minutes from Houston. Seller has home warranty policy and is willing to give buyer one to buyer, company of their choice.' ,`Acres` = '0.1082' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ELDRIDGE PARK VILLAGE SEC 2, BLOCK 3, LOT 35' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4714' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BARRINGTON PLACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Eldridge Park Village Sec 2' ,`TaxAmount` = '4930' ,`TaxRate` = '2.3329' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709042' WHERE `Matrix_Unique_ID` = '207371501' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T17:30:33.400' ,`MLSNumber` = '85920401' ,`ListAgentFullName` = 'Macarena Korth' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.832305' ,`Longitude` = '-96.137730' ,`PhotoCount` = '21' ,`PostalCode` = '77465' ,`RoomCount` = '2' ,`ListPrice` = '99000.00' ,`Status` = 'Active' ,`StreetName` = 'Grand Oak' ,`StreetNumber` = '335' ,`StreetSuffix` = 'Street' ,`City` = 'Palacios' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '932' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller! Newly remodel 932 sq. ft. home inside the gated community of Tres Palacios Oaks. This 1984 home has 2-bedroom & 1 bathroom and cute porch. UPDATE: 4 lots lots totaling 0.52 acres with beautiful oak trees. The two back lots facing Old River Rd North would be a perfect spot for a driveway or to park you RV. The property has two outside metal buildings in great shape for additional storage. Only 5 miles from Matagorda Bay. TPO has a community water supply system, boat launch, boat trailer parking, lighted fishing piers, a swimming pool, children’s playground, outdoor picnic pavilion, and a 10-acre freshwater lake. Call or Text the agent for questions.' ,`Acres` = '0.5236' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRES PALACIOS OAKS S/D, LOT 452-453 & 478-479, LIVE OAK SEC' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '22808' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '80' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '156 - Palacios' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (PALACIOS)' ,`SchoolHigh` = 'PALACIOS HIGH SCHOOL' ,`SchoolMiddle` = 'PALACIOS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tres Palacios Oaks Sub' ,`TaxAmount` = '1055' ,`TaxRate` = '1.9236' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663709042' WHERE `Matrix_Unique_ID` = '208985808' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T17:28:16.480' ,`MLSNumber` = '98060427' ,`ListAgentFullName` = 'Laura Crisp' ,`ListOfficeName` = 'Bob Peltier & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.136106' ,`Longitude` = '-95.563912' ,`PhotoCount` = '33' ,`PostalCode` = '77515' ,`RoomCount` = '0' ,`ListPrice` = '524875.00' ,`Status` = 'Active' ,`StreetName` = 'Mill Road' ,`StreetNumber` = '531' ,`StreetSuffix` = 'Road' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '2512' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Over 2.3 acers of BEAUTIFUL WATER FRONT property on 2 lots both on water front!!! 4 spacious bedrooms gorgeous master bath with shower for 2 and beautiful chandelier lights!!! XL additional 1500 SQ ft garage/workshop which had plenty of room to park extra vehicles and work on projects on one side and one other side an awesome man cave with window unit A/C, TV and a half bath which could easily be converted into EXTRA LIVING/ MOTHER- IN- LAW quarters. Plenty of parking and enough space to park RV \r\nThe Huge Amazing kitchen is has tons of cabinets a GINORMOUS beautiful expensive Island With Cook Top, tons of storage AND there is a LARGE Breakfast Bar too!!! Granite counter tops. Enjoy sitting under covered patio looking at beautiful view of nature and where you can watch deer and kids play! Large living room and much more... Many upgrades!!! \r\nAmenities include access and use of clubhouse/banquet room, pools, play grounds, bayou and lakes to fish in as well as community events.' ,`Acres` = '2.33' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BAR X RANCH SEC 2 (A0038 J B BAILEY) BLK 1 LOT 101 ACRES 1.0' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bar X Ranch Sec 2' ,`TaxAmount` = '4609' ,`TaxRate` = '1.6364' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709042' WHERE `Matrix_Unique_ID` = '210035340' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T17:20:28.093' ,`MLSNumber` = '36260840' ,`ListAgentFullName` = 'Rallin Welch' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Shawn Baksh' ,`SellingOfficeName` = 'Trotwood Realty' ,`Latitude` = '29.756959' ,`Longitude` = '-95.409916' ,`PhotoCount` = '33' ,`PostalCode` = '77019' ,`RoomCount` = '16' ,`ListPrice` = '3799000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Chilton' ,`StreetNumber` = '2104' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6886' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful recently-constructed home was was the 2019 ASID Houston Showhome! Designed by Ryan Gordon and built by Welch Builders. Exterior features of the home include slurried brick, limestone entry, slate roof, copper gutters, flashing and chimney shrouds, gas lanterns, insulated doors and windows, functional shutters, turf backyard and a sparkling pool. Interior features include three Isokern wood burning or gas log fireplaces, 5-7 bedrooms, large formals, an island kitchen with Sub Zero & Wolf stainless appliances, dual staircases, an elevator to the third floor, two powder rooms, and a large covered terrace with outdoor kitchen. The luxurious master suite encompasses the front half of the second floor. There is a vestibule separating the bedroom from the master bath and closet to accommodate different schedules.' ,`Acres` = '0.2579' ,`Area` = '16' ,`BuilderName` = 'Welch Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LTS 22 BLK 52 RIVER OAKS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11233' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other,Slate' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Photos/No Videos,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'River Oaks Sec 03' ,`TaxAmount` = '75596' ,`TaxRate` = '2.5264' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709042' WHERE `Matrix_Unique_ID` = '210051655' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T16:09:20.027' ,`MLSNumber` = '18730532' ,`ListAgentFullName` = 'Helena Hattan' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.461827' ,`Longitude` = '-95.490795' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '2300000.00' ,`Status` = 'Active' ,`StreetName` = 'Tanager' ,`StreetNumber` = '8531' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '5601' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Meticulously crafted by architect Don Purser & Regan Custom Homes, this 5BD/4BA modern farmhouse showplace delivers expansive jaw-dropping designer interiors & remarkable indoor-outdoor lakeside living on\r\nmore than 4 acres in ultra-desirable Sienna Point. Bespoke millwork, one-of-a-kind lighting, soaring beamed ceilings & premium flooring throughout. Relax & entertain in exquisite frml dining & great room. Enjoy chef\'s kitchen w/upscale appliances & massive island. Lg bedrooms & bathrooms provide lavish accommodations for friends & family. Study, laundry room & lg pantry complete the layout. Outside, sprawling covered\r\nflagstone porches welcome phenomenal al fresco entertaining. This prized gated country estate includes\r\na bulkhead pond, 2 barns, animal enclosures, custom entry gate, & 4-car garage with\r\nbuildable space above. Multiple fireplaces, outdoor kitchen & novel splash pad. \"Reindeer Room\" for whatever hobby your heart desires. Outstanding location. Never Flooded!' ,`Acres` = '4.046' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA POINT SEC 2, BLOCK 1, LOT 34, ACRES 4.046' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '176244' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1145' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'Sienna Point Sec 2' ,`TaxAmount` = '26005' ,`TaxRate` = '2.2129' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709043' WHERE `Matrix_Unique_ID` = '210237632' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T17:40:19.517' ,`MLSNumber` = '43467261' ,`ListAgentFullName` = 'Kirk Neal' ,`ListOfficeName` = 'Eastex Real Estate Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.794211' ,`Longitude` = '-95.100485' ,`PhotoCount` = '22' ,`PostalCode` = '77360' ,`RoomCount` = '6' ,`ListPrice` = '179000.00' ,`Status` = 'Active' ,`StreetName` = 'Idlewilde' ,`StreetNumber` = '158' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home features; 2 bedrooms, 2 baths, and a 2 car garage. Recently remodeled kitchen and new floors installed throughout, fresh texture and paint on walls. The garage offers an abundance of space for storage. With the covered patio offering plenty of space for family and friends to hang out, grill, and etc... Great starter home or for someone looking to downsize. Only minutes from Lake Livingston!' ,`Acres` = '0.1928' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'IDLEWILDE ESTATES SECTION 1 BLK 8 LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '127' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Idlewilde Estates Sec 1' ,`TaxAmount` = '2387' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663709043' WHERE `Matrix_Unique_ID` = '210622151' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T16:18:27.893' ,`MLSNumber` = '54948562' ,`ListAgentFullName` = 'Simran Mann' ,`ListOfficeName` = 'Gill Fine Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.910356' ,`Longitude` = '-95.645064' ,`PhotoCount` = '32' ,`PostalCode` = '77095' ,`RoomCount` = '11' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Red Hill' ,`StreetNumber` = '15806' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2906' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this lush 2-story home nestled in the Aberdeen Trails neighborhood. Upon entering the property you will find a formal dining with a unique tiled ceiling and a formal living with a wall of floor-to-ceiling built-ins, along with a spiral staircase that leads you to 2 secondary bedrooms, game room and bathroom. The open concept floor plan flows from the living room into the breakfast + kitchen combo. Kitchen features a beautiful stone accent wall and a large built-in breakfast table. High ceilings in the living room, along with a double-sided fireplace that is also accessible from the potential 4th bedroom / office. This additional room has an en-suite bathroom, walk-in closet and is connected to the primary. Primary suite features new concrete-like tile floors, completely renovated bathroom with double sinks, free-standing tub, large shower and walk-in closet! Long driveway, detached 2-car garage, perfect backyard space for entertaining or kids! Call now to schedule a showing!' ,`Acres` = '' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 3 ABERDEEN TRAILS SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8699' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FIEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Aberdeen Trails' ,`TaxAmount` = '7902' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709043' WHERE `Matrix_Unique_ID` = '210929285' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T17:59:03.373' ,`MLSNumber` = '9233450' ,`ListAgentFullName` = 'Teresita Enriquez' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.864719' ,`Longitude` = '-95.737425' ,`PhotoCount` = '32' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '308000.00' ,`Status` = 'Active' ,`StreetName` = 'Azelea Field' ,`StreetNumber` = '20814' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1773' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a must see property!!!!. This lovely home in the beautiful Jasmine Heights Subdivision! The owner has taken immaculate care of this home. This is an Amazing 3 bedroom one story floor plan with open living spaces! Modern finishes and designer details at every corner of the interior! Hard surface flooring, stainless steel appliances, gorgeous cabinetry, and the list goes on! Wonderful master retreat with separate garden tub and shower! This property also features a covered outdoor patio for your family to enjoy. The property is currently leased and tenants are flexible to move out if the buyer is not interested in honoring the existing lease.\r\n Schedule your appointment today!' ,`Acres` = '0.125' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 1 JASMINE HEIGHTS SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5443' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights Sec 10' ,`TaxAmount` = '6267' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709043' WHERE `Matrix_Unique_ID` = '211059378' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T16:33:49.063' ,`MLSNumber` = '70336915' ,`ListAgentFullName` = 'Deanna Kirksey' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = 'Lisa Clary' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '29.910988' ,`Longitude` = '-95.088135' ,`PhotoCount` = '30' ,`PostalCode` = '77532' ,`RoomCount` = '3' ,`ListPrice` = '289900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Diamondhead' ,`StreetNumber` = '1207' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2274' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICED TO SELL! MUST SEE!! THIS HOME IS IMMACULATE! ONE OWNER - In golf course community. This home has been well maintained, it has high ceilings that boast a wide open living and formal dining area with lots of windows, beautiful kitchen w/island and granite countertops, custom solid wood cabinets and breakfast area. Large primary bathroom with garden tub and separate shower, and walk in closet. Tile flooring throughout and carpet in bedrooms. Covered back porch and beautiful landscaping in the back yard, great for your morning coffee or evening cold beverage. This home has a great location just across the street from the park and walking trails. This community has a golf course and country club, pools and tennis court, parks and splash pad along with private river access with boat ramp and beach area, and lake access with boat ramp and lots of space for a picnic.' ,`Acres` = '0.2401' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 NEWPORT SEC 8' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '10458' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 08' ,`TaxAmount` = '6108' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709043' WHERE `Matrix_Unique_ID` = '211173746' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T16:38:59.687' ,`MLSNumber` = '32441253' ,`ListAgentFullName` = 'Catina Anderson' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = 'Sharhonda Spates' ,`SellingOfficeName` = 'Astute Realty' ,`Latitude` = '29.585011' ,`Longitude` = '-95.469188' ,`PhotoCount` = '29' ,`PostalCode` = '77053' ,`RoomCount` = '10' ,`ListPrice` = '249900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Quail Cove' ,`StreetNumber` = '5434' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1597' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING 2017 Build Modern 2Story 3Bedroom 2&1/2 Bath Home Open Plan\r\nSpacious MASTER BDRM 1st.Floor, complete w/dual separate closets for HIM&HER.MASTER BATH gorgeous ultra \r\ntile Seperate.GARDEN Tub& Shower\r\nGreat recessed lighting throughout Home. FLOORING wood-grain laminate. Carpet in bedrooms.\r\nKITCHEN - w/GRANITE counters& Island w/stainless steel appliances.2 Nice size upstairs bedrooms w/JACK-N-JILL connected Full Bath with seperate area vanities.\r\nBreakfast Room, Family Room, Kitchen/Dining Combo, Utility Room in House. 2 Car Attached Garage\r\n *NO DEED RESTRICTIONS* *LOW TAX RATE* *MISSOURI CITY AREA* *FORT BEND COUNTY*' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'QUAIL BRIDGE GARDENS , BLOCK 1, LOT 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2032' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Quail Bridge Gardens' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709043' WHERE `Matrix_Unique_ID` = '211395999' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T16:24:52.973' ,`MLSNumber` = '85348338' ,`ListAgentFullName` = 'Shelly Mattingly-Arnold' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.484746' ,`Longitude` = '-95.364800' ,`PhotoCount` = '47' ,`PostalCode` = '77578' ,`RoomCount` = '9' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Austin' ,`StreetNumber` = '6702' ,`StreetSuffix` = 'Cove' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2813' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful, well maintained, landscaped Cervelle home on a corner lot in Lakeland Subdivision. This 4 bedroom, 3 bath home offers tile in wet areas & carpet throughout all other areas, a formal dining room that could be converted into an office/study or additional room, a media room, large family room with gaslog fireplace, guest suite, primary bedroom in back of home with private bath that has double sinks, vanity area, separate shower & soaking tub, granite countertops, stainless steel appliances, lots of cabinet space for storage, walk in pantry, utility room in home, & a generac for backup power to the home. The backyard has plenty of room to kick back, relax, or entertain. The two car garage is oversized with attached Porte Cache for additional covered parking & above the garage is framed out for storage & could be finished out if you desired. Great schools nearby, easy access to Hwy 288 & the Medical Center. Call today to schedule your private tour.' ,`Acres` = '0.2419' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKELAND SD SEC 4 (A0493 HT&BRR) (MANVEL) BLK 2 LOT 65' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10537' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeland SD Sec 4 A0493 Ht&Br' ,`TaxAmount` = '10684' ,`TaxRate` = '3.5974' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709043' WHERE `Matrix_Unique_ID` = '211468529' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T17:25:45.490' ,`MLSNumber` = '35570847' ,`ListAgentFullName` = 'Laura Crisp' ,`ListOfficeName` = 'Bob Peltier & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.249259' ,`Longitude` = '-95.360962' ,`PhotoCount` = '10' ,`PostalCode` = '77534' ,`RoomCount` = '3' ,`ListPrice` = '114895.00' ,`Status` = 'Active' ,`StreetName` = 'Wolf Glen' ,`StreetNumber` = '130' ,`StreetSuffix` = 'Street' ,`City` = 'Danbury' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1708' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super huge Primary bedroom! Over 1 acre of beautiful land full of possibilities with fruit trees and ready for garden and more! Smaller area fenced in near house perfect for kids or pets in and to keep other animals out. There is a shed/workshop and covered patio. Beautiful wood laminate floor AND Built ins.\r\nLOOK through/pass through fireplace can see/access fire from both Den and Living room. Amazing chiefs\' kitchen with tons of counter space and cupboards. ALL APPLIANCES STAY! Home needs some TLC but is a diamond in the rough.' ,`Acres` = '1.18' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'WOLF GLEN ESTATES (A0014 H AUSTIN), LOT 28 COM B, ACRES 1.18' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '51401' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '15 - Danbury' ,`SchoolElementary` = 'DANBURY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DANBURY HIGH SCHOOL' ,`SchoolMiddle` = 'DANBURY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wolf Glen Estates' ,`TaxAmount` = '836' ,`TaxRate` = '2.1535' ,`WaterSewer` = 'Aerobic,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709044' WHERE `Matrix_Unique_ID` = '211735791' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T17:00:30.573' ,`MLSNumber` = '12317744' ,`ListAgentFullName` = 'Srinivasan Pillaipakkam' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.903360' ,`Longitude` = '-95.644078' ,`PhotoCount` = '31' ,`PostalCode` = '77095' ,`RoomCount` = '7' ,`ListPrice` = '309999.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Falls' ,`StreetNumber` = '8454' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2348' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Home in Copperfield with a stunning kitchen. This house boasts a lighted pantry, volume ceiling in the living room and excellent curb appeal. Sizeable backyard and detached garage complete the main features of this gem in Copperfield middlegate village. This house has a large living room with 2 storey sloped ceiling for a majestic look. The family room looks into the kitchen ideal for some quality family time. Zoned to highly ranked CY-FAIR ISD schools. Come out and see this beauty!' ,`Acres` = '0.1785' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 31 COPPERFIELD MIDDLEGATE VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7777' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FIEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Copperfield Middlegate Village' ,`TaxAmount` = '4812' ,`TaxRate` = '2.3216' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663709044' WHERE `Matrix_Unique_ID` = '211758255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T16:29:21.290' ,`MLSNumber` = '91492907' ,`ListAgentFullName` = 'Abigail Steinhagen' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.904260' ,`Longitude` = '-95.734118' ,`PhotoCount` = '8' ,`PostalCode` = '77433' ,`RoomCount` = '4' ,`ListPrice` = '469990.00' ,`Status` = 'Active' ,`StreetName` = 'Coral Lake Dr' ,`StreetNumber` = '7603' ,`StreetSuffix` = '' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2246' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Tricoast Homes, this Melbourne floor plan is a gorgeous WATERFRONT home located in the Marvida community. This home welcomes you with trend-conscious flooring that leads you to an updated kitchen complete with granite countertops and stainless steel appliances. Relax in the tub in the master bathroom , featuring luxurious designs with modern finishes. Unwind outside on the texas-sized patio. Within each Tricoast home you will find high vaulted ceilings in the living room. Living here you can enjoy a community recreation center with community lakes and water features, a 3,000 square foot clubhouse, pool, playground, dog park, and tennis and sand volleyball courts. Contact us today for more information!**FRONT AND BACKYARD IRRIGATION!!**' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Tricoast Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14, Block 3, Section 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709044' WHERE `Matrix_Unique_ID` = '211786045' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T16:28:55.007' ,`MLSNumber` = '30616893' ,`ListAgentFullName` = 'Abigail Steinhagen' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.904260' ,`Longitude` = '-95.734118' ,`PhotoCount` = '8' ,`PostalCode` = '77433' ,`RoomCount` = '4' ,`ListPrice` = '469990.00' ,`Status` = 'Active' ,`StreetName` = 'Coral Lake Dr' ,`StreetNumber` = '7606' ,`StreetSuffix` = '' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Tricoast Homes, this Mallorca floor plan is a gorgeous home located in the Marvida community. This home welcomes you with trend-conscious flooring that leads you to an updated kitchen complete with granite countertops and stainless steel appliances. Relax in the tub in the master bathroom , featuring luxurious designs with modern finishes. Unwind outside on the texas-sized patio. Within each Tricoast home you will find high vaulted ceilings in the living room. Living here you can enjoy a community recreation center with community lakes and water features, a 3,000 square foot clubhouse, pool, playground, dog park, and tennis and sand volleyball courts. Contact us today for more information!**FRONT AND BACKYARD IRRIGATION!!**' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Tricoast Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, Block 1, Section 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709044' WHERE `Matrix_Unique_ID` = '211787318' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211977325','1663709044','211977325','2022-09-10T16:32:35.417','93838374','Ashley Martins','Martins Realty','','','29.696613','-95.768943','50','77407','11','434900.00','Active','Lakewind Park','23503','Lane','Richmond','2','1','4','3051','Single-Family','Take a closer look at this deceptively sizeable 1.5 story home with Lakefront and two beautiful fountains in the back. Stone elevation upfront with side loaded garage. Plush greenery yard with two trees. Great backyard with covered patio for the cool summer lake breeze. Step into a well appointed kitchen with upgraded appliances, with an island. \r\n\r\nAll spaces are quite big, but no disappointment in the oversized master bedroom with it\'s own living space for a couch and TV, or private work area. Master closet is huge. The gameroom upstairs can be used as 5th bedroom. The metal fence in the backyard allows for unobstructed view of a gorgeous lake. You have arrived home at last.','0.1865','37','First Texas Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Fort Bend County North/Richmond','Central Gas','1','PARKWAY LAKES SEC 1, BLOCK 2, LOT 32','Subdivision Lot,Water View,Waterfront','8125','Appraisal District','','950','0','','2','','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','HUBENAK ELEMENTARY SCHOOL','FOSTER HIGH SCHOOL','WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1.5','Contemporary/Modern,Ranch','Parkway Lakes Sec 1','7879','2.7615','Public Sewer,Public Water','2004','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212206652','1663709044','212206652','2022-09-10T16:22:53.107','95604092','Victor Correa','HomeSmart','','','29.584386','-95.151154','30','77062','3','299900.00','Active','Amber Knoll','1418','Court','Houston','2','0','3','1948','Single-Family','Welcome home, Freshly painted updated 3 bedroom, 2 bath ready to call home. Convenient located to ease your drive home, minutes from I-45! New paint all thru out, New carpet. Price to sell today!','0.1404','7','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Clear Lake Area','Central Gas','1','LT 44 BLK 2 BAY POINTE SEC 4','Subdivision Lot','6117','Appraisal District','','95','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','9 - Clear Creek','NORTH POINTE ELEMENTARY SCHOOL','CLEAR BROOK HIGH SCHOOL','CLEARLAKE INTERMEDIATE SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Bay Pointe Sec 04','6848','2.5769','Public Sewer,Public Water','1994','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212251358','1663709044','212251358','2022-09-10T16:51:14.797','57805328','Stephany Williams','Lakeside Realty Group, LLC','','','30.387588','-95.615918','37','77356','10','364999.00','Active','Pine Chase','3002','Drive','Montgomery','2','0','3','2298','Single-Family','This home is a 3/4 bedroom with 2 bathrooms located in Walden on Lake Conroe. Situated on a corner lot & close to Lake Conroe, the marina, yacht club, & 3 neighborhood restaurants. The interior has a welcoming foyer, formal dining, breakfast bar & breakfast room, stainless appliances & open to the downstairs living area with a cozy fireplace. Primary has sitting area & a large bathroom w/double sinks & a vanity area, large walk-in closet as well. Secondary rooms are on the opposite side of the home w/their own bathroom. Upstairs you will find a very long & spacious gameroom! Of course this room can be used for so many things including a 4th bedroom. This is a fabulous subdivision & always so popular! Lots of entertainment in the area with tennis, swimming pools, parks, Lake Conroe & tons of restaurants. Walden on Lake Conroe is also home to a fabulous affordable popular golf course!','0.2106','39','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Lake Conroe Area','Central Electric','1','WALDEN 09, BLOCK 49, LOT 39','Corner,In Golf Course Community,Subdivision Lot','9175','Appraisal District','','1050','0','','2','Double Oven','0','','','Electric Cooktop','','Composition','37 - Montgomery','MADELEY RANCH ELEMENTARY SCHOOL','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1.5','Other Style,Traditional','Walden 09','5370','2.2242','Water District','2000','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212329777','1663709044','212329777','2022-09-10T17:24:51.763','66510864','Merlin Tankoua','Texas United Realty','','','29.380530','-95.001607','19','77591','3','252000.00','Active','Amburn','311','Road','Texas City','2','0','3','1550','Single-Family','This lovely 3 bedrooms 2 bathrooms property is ready for you and your love ones to enjoy all it has to offer such as new HVAC system new 30 years shingle roof. Also has new luxury vinyl plank , new appliances with new kitchen cabinets.\r\nBoth bathrooms feature new tiles, new tub, faucets, toilets.\r\nLot is on +/- 1/2.acre of land with several majestic trees surrounding the property.','0.4597','33','Bar x','','','','Sellers Disclosure','1','','','Texas City','Central Electric','0','ABST 2 PAGE 6 LOT 8 BLK 1 SUPER CITY NO 4','Cul-De-Sac,Subdivision Lot','20024','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','52 - Texas City','SIMMS ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Lockbox Front,Vacant/Unoccupied','Builder','1','Traditional','Super City 4','3645','2.582','Public Sewer,Public Water,Water District','1956','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212372678','1663709044','212372678','2022-09-10T16:14:20.963','72906568','Billy Martinez','HomeSmart','','','29.789248','-95.177228','36','77015','3','229500.00','Active','Hollypark','13918','Drive','Houston','2','0','3','1531','Single-Family','OVERSIZE LOT !!!!!! Beautiful well taken care of home located in close proximity to the major highways, schools, and shopping. The kitchen comes equipped with plenty of cabinets/counter space , granite countertops . Whole house has been recently remodeled and ready for move in.','0.3159','2','','','','','Sellers Disclosure','','','','North Channel','Central Gas','1','LT 5 BLK 10 (HCFCD ESMT OF .1469 AC) WOODFOREST SEC 3','Subdivision Lot','13760','Appraisal District','','250','0','','2','','0','','','','','Composition','21 - Galena Park','NORTH SHORE ELEMENTARY SCHOOL','NORTH SHORE SENIOR HIGH SCHOOL','NORTH SHORE MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Woodforest Sec 03','3884','2.5294','Public Water','1963','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212372715','1663709044','212372715','2022-09-10T17:58:41.707','41822581','Tanner Holligan','Kristie Zorens Realty, LLC','','','30.458866','-95.475103','23','77378','6','271000.00','Active','Coaltown','15144','Road','Willis','2','0','2','1218','Single-Family','Quiet.Spacious.2bed 2bath at 1218sqft sitting on just under 1 acre. This masterfully built Stone&Brick Home includes; Tile flooring, custom cabinets, gas range, plenty of square footage for a 2 bedroom home, and metal roof that extends over the porch/patio for rest and relaxation during those long work weeks or hot summer days. You wont have to worry about having your privacy as this home was designed to be tucked away, and out of sight. Whether looking to downsize, or maybe just want something to call your own that\'s away from the busy city, this home couldn\'t be a better fit. You wont want to miss the opportunity to call this home your next!','0.84','19','','','Electric Dryer Connections,Washer Connections','','Other Disclosures','1','','','Willis Area','Other Heating','1','S216007 - Arrowhead Lakes 07, BLOCK 25, Lot 8,9,23,24','Other,Subdivision Lot,Wooded','36450','Appraisal District','','120','0','','0','Gas Oven,Single Oven','0','','','Gas Cooktop,Gas Range','','Aluminum','56 - Willis','PARMLEY ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','LYNN LUCAS MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Other Style,Traditional','Arrowhead Lakes','','','Septic Tank','2012','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212376445','1663709044','212376445','2022-09-10T17:35:29.657','22064120','Casey Waters','Coldwell Banker Apex, REALTORS LLC','','','32.072414','-96.800255','29','76641','5','155000.00','Active','Fm 667','8281','','Frost','2','0','3','1946','Single-Family','This spacious home lies just outside the city limits of the quiet town of Frost, TX. The massive back yard pairs wonderfully with the spacious home to breath in the fresh Texas air. The open kitchen features lots of counter space and a coveted double oven. The huge garage accommodates a variety and combination of uses. The home has a storm shelter for added safety when the storms come through. If you’re ready to slow down and enjoy the sunsets over your back yard, this great home is ready for you.','1','84','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','','','','Central Electric','0','ABS A10286 J FRENCH ABST TRACT 9 1.0 ACRES','Other','43560','Appraisal District','','','0','','3','Double Oven,Electric Oven','0','','','Electric Cooktop','','Aluminum','532 - Frost','FROST ELEMENTARY SCHOOL (FROST)','FROST HIGH SCHOOL','FROST HIGH SCHOOL','Accompany,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Other Style','J French Abst','2088','1.9576','Public Water','1964','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212392647','1663709044','212392647','2022-09-10T16:58:33.747','70520730','Yaritza Cruz','CJM Realty Advisors','','','29.481522','-94.929461','17','77539','2','320000.00','Active','15th st','1037','','San Leon','2','0','2','1073','Single-Family','Welcome to this beautiful 2 story new construction home. This home features 2 bedrooms, 2 baths, each bedroom has its own balcony with ocean views. As you walk in, you see an open floor plan, with an open living room and kitchen concept. Kitchen has a nice big island counter top, appliances included. Has its own separate laundry room. Plenty of parking space underneath the home and a well maintained backyard. SELLING FURNISHED.','0.0769','33','S&D Coastal Const.','','Electric Dryer Connections,Washer Connections','','Exclusions,Owner/Agent','1','','','Bacliff/San Leon','Central Electric','0','ABST 10 A EDWARDS LOT 9 BLK 184 SAN LEON','Patio Lot,Water View','3350','Appraisal District','','','1','Never Lived In','','','0','','','','','Composition','17 - Dickinson','SAN LEON ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','JOHN AND SHAMARION BARBER MIDDLE SCHOOL','Lockbox Front','Appraisal District','2','Contemporary/Modern','San Leon','186','2.521','Public Sewer,Public Water','2021','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212394450','1663709044','212394450','2022-09-10T16:41:22.877','54674704','Justin Dickey','Keller Williams Professionals','','','30.220326','-95.160583','50','77372','8','305595.00','Active','Babe Ruth','26031','Drive','Splendora','2','1','4','2123','Single-Family','Brand new beautiful 2 story 3 bedroom 2 1/2 bath with a large living room, spacious kitchen, formal dining room, and 2 car garage. Colina Home features gray cabients, gorgeous granite kitchen countertops, kitchen includes recess lighting, high ceilings, laminated vinyl (wood look) flooring throughout the home, 2\" blinds throughout the home, Stainless Steel Appliances including 5 burner gas range, 42\" gray cabinets in kitchen, Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen & bathrooms. Masterbath features a large garden tub with separate shower, dual marble vanities, large walk-in closet. 10-year warranty on frame and foundation, 25-year warranty on roof, and 30-year warranty on Hardi Plank. Covered back patio and extreme energy efficiencies to reduce cost. This Home is Move in ready Nov/Dec 2022. Call to schedule a showing now This home will be move in ready NOVEMBER/DECEMBER 2022 \r\nPHOTOS ARE REPRESENTATIVE','','40','Colina Homes','','Electric Dryer Connections','','Mud','1','','','Cleveland Area','Central Gas','1','Lot 23 block 2 Section 4','Subdivision Lot','8600','Survey','','360','1','To Be Built/Under Construction','2','','0','','','Gas Range','','Composition','47 - Splendora','PEACH CREEK ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Accompany','Builder','2','Traditional','Splendora Fields','','2.62','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212394870','1663709044','212394870','2022-09-10T16:58:24.200','35847366','Justin Dickey','Keller Williams Professionals','','','30.219408','-95.161967','46','77372','8','305570.00','Active','Cooperstown','26210','Way','Splendora','2','1','4','2123','Single-Family','Brand new beautiful 2 story 3 bedroom 2 1/2 bath with a large living room, spacious kitchen, formal dining room, and 2 car garage. Colina Home features gray cabients, gorgeous granite kitchen countertops, kitchen includes recess lighting, high ceilings, laminated vinyl (wood look) flooring throughout the home, 2\" blinds throughout the home, Stainless Steel Appliances including 5 burner gas range, 42\" gray cabinets in kitchen, Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen & bathrooms. Masterbath features a large garden tub with separate shower, dual marble vanities, large walk-in closet. 10-year warranty on frame and foundation, 25-year warranty on roof, and 30-year warranty on Hardi Plank. Covered back patio and extreme energy efficiencies to reduce cost. This home is will be move in ready NOVEMBER/DECEMBER 2022\r\nPHOTOS ARE REPRESENTATIVE','','40','Colina Homes','','Electric Dryer Connections','','Mud','1','','','Cleveland Area','Central Gas','1','Lot 11 block 1 Section 4','Subdivision Lot','12500','Survey','','360','1','To Be Built/Under Construction','2','','0','','','Gas Range','','Composition','47 - Splendora','PEACH CREEK ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Accompany','Builder','2','Traditional','Splendora Fields','','2.62','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212395340','1663709044','212395340','2022-09-10T17:25:46.113','21353599','Justin Dickey','Keller Williams Professionals','','','30.220034','-95.162776','50','77372','8','320100.00','Active','Mel Ott','15412','Court','Splendora','2','1','4','2123','Single-Family','Brand new beautiful 2 story 3 bedroom 2 1/2 bath with a large living room, spacious kitchen, formal dining room, and 2 car garage. Colina Home features gray cabients, gorgeous granite kitchen countertops, kitchen includes recess lighting, high ceilings, laminated vinyl (wood look) flooring throughout the home, 2\" blinds throughout the home, Stainless Steel Appliances including 5 burner gas range, 42\" gray cabinets in kitchen, Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen & bathrooms. Masterbath features a large garden tub with separate shower, dual marble vanities, large walk-in closet. 10-year warranty on frame and foundation, 25-year warranty on roof, and 30-year warranty on Hardi Plank. Covered back patio and extreme energy efficiencies to reduce cost. This home is will be move in ready NOVEMBER/DECEMBER 2022\r\nPHOTOS ARE REPRESENTATIVE','','40','Colina Homes','','Electric Dryer Connections','','Mud','1','','','Cleveland Area','Central Gas','1','Lot 28 block 3 Section 4','Subdivision Lot','12500','Survey','','360','1','To Be Built/Under Construction','2','','0','','','Gas Range','','Composition','47 - Splendora','PEACH CREEK ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Accompany','Builder','2','Traditional','Splendora Fields','','2.62','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212395797','1663709044','212395797','2022-09-10T17:46:10.293','59794239','Justin Dickey','Keller Williams Professionals','','','30.220678','-95.161691','37','77372','10','290420.00','Active','Honus Wagner','25433','Way','Splendora','2','0','3','1754','Single-Family','Brand new beautiful 1 story 3 bedroom 2 bath with a study and 2 car garage. Colina Home features gray cabients, quartz kitchen countertops, kitchen includes recess lighting, high ceilings, laminated vinyl (wood look) flooring throughout the home, 2\" blinds throughout the home, Stainless Steel Appliances including 5 burner gas range, 42\" gray cabinets in kitchen, Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen & bathrooms. Masterbath features a large garden tub with separate shower, dual marble vanities, large walk-in closet. 10-year warranty on frame and foundation, 25-year warranty on roof, and 30-year warranty on Hardi Plank. Covered back patio and extreme energy efficiencies to reduce cost. This Home is Move in ready Nov/Dec 2022.\r\nPHOTOS ARE REPRESENTATIVE','','40','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','Cleveland Area','Central Gas','1','Lot 15 Block 3 Sec 4','Subdivision Lot','11974','Survey','','360','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','47 - Splendora','PEACH CREEK ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Accompany','Builder','1','Traditional','Splendora Fields','','2.62','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212396049','1663709044','212396049','2022-09-10T17:45:52.960','93052940','Justin Dickey','Keller Williams Professionals','','','29.437789','-95.434424','37','77583','8','492740.00','Active','Amador Peak','10626','','Rosharon','3','1','4','2922','Single-Family','This gorgeous Colina Home has Amazing offerings! When you walk through the front door you will feel right at home. This home offers 4bedrooms,3.5bathrooms,dining & 3car garage! The living room, kitchen,area are open to each other with high ceilings. The kitchen features oversized island with seating,42\" cabinetry,& spacious walk in pantry. The primary bedroom is tucked away in the back of home with a spacious en suite bathroom & walk in closet. There is a Huge covered back patio great for grilling and fun. Rosharon\'s best communities offering everything a family friendly community want + amenities located in Sterling Lakes, with a spashpad, fitness center,Basketball Court, Lakes & Parks. Crystal Lagoon coming soon! Close to Pearland, Alvin,Manvel, Lake Jackson,30 minutes from Downtown Houston. SHOP AND WORK IN THE CITY AND\r\nCOME HOME TO A QUIET PEACEFUL COMMUNITY @ SIERRA VISTA!','','5','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Alvin North','Central Gas','1','Lot 7 Block 2 Sec 7','Subdivision Lot','7500','Survey','','1100','1','To Be Built/Under Construction','3','Gas Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Accompany,Leave Business Card','Builder','2','Contemporary/Modern','Sierra Vista','','','Public Sewer,Public Water','2022','Builder'); --> New record created successfully